I have built an Access database for an art gallery and am having trouble designing a form that will allow me to record several pieces of art sold on one invoice. Each piece of art has a unique stock number, which is the key field of the Inventory Table. I've also created a Sales Table to act as a bridge between the Inventory Table and the Clients Table. Unless I can figure out how to enter more than one piece of art on the Sales Form, I'll have to enter the same information (e.g. Invoice No., Client ID, Artist ID, etc.) more than once for sales that involve more than one piece.

I know that there is probably a simple solution to this problem, but I can't seem to find it. (This is my first experience with a relational database, so please excuse my ignorance. :()


Richard Murphy
Sedona, AZ

You can use a subform on your main form. The two will be linked by what you set up in the subform wizard. Then, when you enter an item in the subform, it will be recorded for you in the sales and inventory table. See the Northwind database provided with Access and there is a good example of this there.

RU1