I have been struggling with this. I have a simple DB with 2 Tables; "Product" and "CustomerOrder".
I need to create a new record in the CustomerOrder Table by selecting a variable number (up to as many as 20) of Products from the Product Table.
I would like to design a form with a search button where the user will enter text (Field1 from Product Table) to build the Customer Order record.
All other Fields from the Product Table will then be added to the Customer order record.
I will then need to generate a Report to list the Customer Order # along with all of the Products that were added.
T think I may be making this more complicated that it needs to be.
Any help would be greatly appreciated!