Multiple order records

[michael g]

hey there just a weee quick question, i am creating an order tracking database, now i have a form with all the customer details on it. then i have a subform which displayes all of the previous order information. now the link between the customer and order is the customer ID, which is unique to ech feild. and in the order subform the order number is unique... however, sometime there cane be multiple orders made @ one time...e.g a man orders 3 jumper and 2 pairs of trousers, i want these to have teh same order number but to be displayed as to diffrent items on the order form... is there any way to do this.. cheers


michael

 

[Hayley Baxter]

Hi Michael

Thanks for your email but I am sorry I cannot help you on this occasion, I do not know how you can achieve this. Are you still with the company? haven't seen you around for a bit!

Good luck anyhow
Hayley

 

[DaniBoy]

Pat is right, Always!!! jeje

To make it easy do the following:

One table named: Customers
Another Table Named: Order Details
Another Table named: Products

you will now create a many to many relationship,

from customers to order detail and from products to order details. now on th order details you will have two primary keys, that are the Customers ID and the Product ID also your other fields like qty ect.

Hope this helped!!

DaniBoy