MIcrosoft Access SubForm

  ninder 19:56 09 Mar 03
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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…