This is a tough one to explain so I am going to do my best. If you need more information on what I am trying to do, just ask.
So, I have two tables. One is titled “W/O’s Closed” and the second table is titled “SHS Products.” The meaning of SHS is irrelevant, so I will not go into detail on what it stands for. Anyways, in the “W/O’s Closed” table, there is a field titled “Items Sold:” in which I have linked to the “SHS Products” table. However, what I am trying to do, is when a customer purchases a product in multiple quantities, I can not link the same record from “SHS Products” in the “Items Sold:” field on the “W/O’s Closed” table to indicated the customer purchased two of the same products. I’ll try to attach pictures of what I am wanting to do, so that you can get a better idea. Thanks for any help in advance.