Report Source

You chose to ignore my recommendation and listen to someone who is only bent
on stalking me in the newsgroups. Now you see what kind of help he provides.

Steve


"Darlene" wrote in message
...
Thank you. Having to design this DB based on my minimal knowledge of all
the
features has been a REAL challenge. I will try to express the out come I
am
looking for.

In this database there are several tables, however, two of them I would
like
to focus on:

TblSchool
School ID (key)
contains the name, address, contact information of the schools

TblRes
Res ID (key)
School ID
field-Program Type **(Dance, Theatre, Early Learning)
field-Res Type ** (Tap, Poetry, Ballet, etc)
also identifies residency information, cost, time...

Below is the explanation of what I am seeking to accomplish. I have
designed forms to be used as documents (example: invoices and contracts).
I
will use the invoice in my explanation:

Example - Washington School purchased 2 dance residencies (1 tap, 1
ballet) and 1 theatre (1 poetry). Each residency is identified by its own
number in the table. so in the tbleRes, Washington school has purchased
the
following

Res Id School ID School Program Pro-Type
1 125 Washington School Dance Tap
2 125 Washington School Dance Ballet
3 125 Washington School Theatre Poetry

Thus, the invoice (form) should read as follows:

Quantity Description Per Unit cost
Total Due
2 Dance Tap and Ballet $1.00
$2.00
1 Theater Poetry $1.00
$1.00
Total
$3.00
What I am seeking help on is how to program the individual residency
descriptions so that each residency is identified when more than one of
the
same program has been purchased. In this case, the dance program has been
purchased twice, though they are different types.

I need instruction on how to program the form to look like this. By
understaning how this programming works will help resolve the same
situation
I have with capturing the correct information need for the contracts.

I hope this explanation makes sense. Thank you for any help that you can
offer me!!!


"Keith Wilby" wrote:

"Darlene" wrote in message
...


I am not clear on why I would
need to change my database design and add the additional tables as you
suggested. Please explain.



The short answer is that you haven't posted enough information about your
tables and relationships for anyone to assess whether or not your design
is
sound. $teve's stock reply in situations like this is to rubbish the
design
in the hope that the poster will become confused and ask for his (paid)
help. The link in Arno's post will tell you all about $teve's
solicitations
for work.

The chances are that you *don't* need to redesign your app but without
more
information no-one can make that assessment. I think that might be what
Jeff was driving at.

Keith.
www.keithwilby.co.uk

"Steve" schreef in bericht
m...
You chose to ignore my recommendation and listen to someone who is only bent on stalking
me in the newsgroups. Now you see what kind of help he provides.

Steve

--
Get lost $teve. Go away... far away....
This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...

OP: If not helped by now you should post a clear question again...
Surely someone will help for FREE.

Arno R

"Steve" wrote in message
m...
You chose to ignore my recommendation

Which was "throw away what you've done and start again". Hardly worthy now,
was it?

and listen to someone who is only bent on stalking me in the newsgroups.

Play by the rules and that will stop. You have the power.

Now you see what kind of help he provides.



At no stage did I offer any. I thought that, by providing sufficient
information, *someone* might be able to help. I didn't feel qualified to
help in this instance so I remained silent. You should try it.