MIcrosoft Access SubForm

  ninder 19:56 09 Mar 2003
Locked

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.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?