Entering Multiple Sale Items on a Form
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. :()