Order Forms (easy i imagine)

[MLife]

Hi,im trying to create an order form,i have tables of customer,cd,order and order item.

Im trying to create an order form where the user selects the customerid which then creates an order number (ive done this bit)

But i don't really know where to start in creating a subform for the items,i want a subform where i select the items from the cd table.

I know this is probably easy but im clueless when it comes to access.

Any tips,steps etc would be appreciated.
Thanks

Rich

 

[Peter D]

I suggest you start with the Orders.mdb sample database that comes with Access. It may have 90% of what you need.

Hope this helps,

 

[MLife]

Hi,where is the file located? The only sample database i have is the northwind one?

 

[MLife]

Any other ideas?
im sure ive done this before and created a query somewhere