Search results

Thanks guys, I feel there's hope! First, for dK. I have no need for quantities. Inventory is restaurant equipment but it is easier to think of in terms of an antique shop. There is only one of everything. As for the type of requery, I have found that I have to requery the underlying query...

I think you could figure it out, but that's not really the issue I'm having. I can do as you say with all the Purchase records displayed in the combo box so that a user can pick an Item Name and the field will show the Item Name but still correctly store the Item ID which is an autonumber. I...

I have the same issue and haven't gotten any replies.

I have tried my best to find the answer in another thread, but haven't found anything that worked. I am making a simple inventory database with Purchases, Sales Orders, and Transactions tables. Purchases has Item ID (PK), Item Name, and Cost. Sales Orders has Sales ID (PK), Sales Date, and...