Hi all! this is very complicated to describe, but i will try my best! I have created a very simple database in which i have a customer table (CustID, Name etc) and Products tbl (ProductID, Product name etc)and have linked the 1 to many relationship with a orders table. the fields in this tbl are Invoice ID, Date, CustomerID, ProductID, Quantity and Amount. Now i wish to create a data entry form so that the customer can order many products (but it must contain a unique InvoiceID and date i.e. all those listed in the orders table). is this possible? As from this i wish to create a simple invoice with all the customers orders. I think i need a subform but am not sure. pls help!!!!!
This thread is now locked and can not be replied to.