Help!
I'm trying to create a basic spreadsheet / database where I can allocate stock on loan to sites accross the company so I can see where it is and 'check' it back into our stock list once its been return.
I have 2 tabs - one listing the items / assets in a simple table and the other tab lists the locations (reference and their full address)
can anyone help?
Last edited by sammyjamting; 03-10-2016 at 11:37 AM. Reason: typo
your stock record will have a field [LoanedTo]
if empty, you have it,
if it has the tCustomer.ClientID in the field, then they have it.
any returning stock gets set to null.
But tAudit file will keep track of the in/out dates
[client], [status], [stockID], [Date]
123, OUT, 553, 1/1/16
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks