I am attempting to create a database of my entire inventory of items for my Antique Store.
When selling an item, I am logging the transaction and linking the Item # to that transaction.
Of course I cannot sell an item more than once, so I was wondering if there is a way to declutter the possible selections for linking a record.
I sell item #1 and create a transaction ID for it. I link item #1 to that transaction ID.
I sell item #2 and create a transaction ID for it. I do not want to see item #1 as a possible record to link to.
Is this possible?