Table Relationships and design

bowks14

Registered User.
Local time
Yesterday, 23:48
Joined
Jun 4, 2008
Messages
15
Hi all,

Here is what I would like to do, and I hope someone can help me:

I want to build an Access database that tracks ticket sales. Here are the tables I have so far:

Customer: customerID, companyname, address, email, phone, etc.
Orders: orderID, customerID (to link to which customer made the purchase), orderDate, paymentreceived (yes or no)
Order Details: orderdetailID, orderID (links back to order table), productID, quantity, unitprice
Products: productID (links back to order details), prodcutName, unitprice

Somehow, I think I am making this way more complex than it needs to be.. Once I have the relationships set up correctly, I'd like to make one solid form that has the basic info to record the order (customer info, what the order consists of, whether or not it is paid, etc.) I am thinking subforms might be the way to go there...

Then ultimately, I'd like to be able to generate reports with the info as well...

Thanks in advance!
 
Nope, looks good to me. Form/subform set up with combo boxes for customer and product and the job's a goodun.
 
Thanks for the quick reply..

I am still a little lost though. Can you explain how it should be setup from the start? I don't think my relationships are set up the right way?
 
I don't understand. Your relationships are fine. You say that the product ID links back to order details when in reality it's the other way round, but in terms of setting up your tables that makes no difference at all.
 

Users who are viewing this thread

Back
Top Bottom