If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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 |
#22
|
|||
|
|||
Report Source
"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 |
#23
|
|||
|
|||
Report Source
"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. |
Thread Tools | |
Display Modes | |
|
|