Hello ,
I would like to create a stores receiving and dispatching database. I would like to know how would one go about setting up a table structure to allow the following:
I would ideally have 4 tables. 1.Stock Items 2.PO Numbers 3.Recieving 4.Dispatch
What I would like to accomplish is to receive/dispatch stock on existing stock codes attached to a PO number.
Therefore I would like to try and create something where I can enter a PO number and list multiple stock items to that number. When displaying the record of the PO number thus would return the items attached.
Any advice would be appreciated.
Thanks in advance.