Is there a way I can add the same record twice in a linked record field? I’m building a product sales database. When I have 2 of the same item in a customer order, I can’t figure out how to add the same item twice in the order record. I’d rather not ...
Two of the same items is rare, so I’ll go with your second recommendation to have a second record for the item in the products table.
Thanks so much for your help!
