hi!!
This is probably gonna be a long post and i'll like to thank everyone that's willing to take the time to help me
Background, engineering student that's given a weird task to create a database for a warehouse.
Story:
receive stocks from a supplier (each item has their own barcode that can be scanned using a barcode scanner)
scan each item's barcode and press search
bring up the item details from the invoice and check to see if the quantity is correct
at the same time
check if it has existing stocks to find the shelf location for storage,(add the quantity from invoice to existing quantity) if not
choose a location to be stored at (Example: shelf 20)
-------------------------------------------------------------------------------------------
What I have now is 2 separate tables:
Invoice (for checking quantity)
Important Fields
scan code
item name
Quantity_Invoice
Inventory (for adding quantity and allocate new shelf for each item)
Important Fields
scan code
item name
Quantity_Inventory
shelf
I have borrowed some access books from the library but doesn't seem to help me much ):
I have little background in using access with no lessons from school~