Search results

The item ID example: Item ID: 123CCA Description: Scanner Color:White If I take the inventory for that day and I see that item ID: 123CCA is physically here, I go into the inventory form and try to enter it, but if the item has already been entered before, I want a message to be displayed...

The ID is manually imputted because sometimes we have the same item back in the office and sometimes we have new ones.

I've created a database that keeps an inventory of items that are in and out of the office. Each item has an ID number. Inventory is taken daily and entered in a form. I want to prevent users from entering an item that's already in the inventory. I know it's under the 'Before Update' field, but...