Hi there, I'm quite new in Access so I need some help!
I'm creating a form to manage purchasing items.
I have a table with the item code and the quantity.
But I want to create a unique number for each product that I bought. (I need to track each item in a process)
I was thinking to create another table with an AutoNumber, but I don't know how to say for "Xitem and quantity = 3" repeat Xitem 3 times creating 3 new ID for each item.
If you can help me with some suggestion will be great!
I'm creating a form to manage purchasing items.
I have a table with the item code and the quantity.
But I want to create a unique number for each product that I bought. (I need to track each item in a process)
I was thinking to create another table with an AutoNumber, but I don't know how to say for "Xitem and quantity = 3" repeat Xitem 3 times creating 3 new ID for each item.
If you can help me with some suggestion will be great!