Demo Stock Tracker

[Guest]

Hello,

I'm trying to create a database to allow us to track the movement of our
demonstration stock.

I have a table which has a record of each piece demonstration stock,
a table which records each Customer,
a table for for each Pro-Forma Invoice Header,
a table for Pro-Forma Invoice Details.

I need a form to book each piece of stock going out to a customer, and
provide a pro-forma invoice.

Then I need a form to record the return of each piece of stock, to close off
the loan transaction and show that the item is available for loan again.

What is the simplest way of doing this?

Many thanks.

 

[Guest]

simplist way is to hire someone......(just kidding...)

it looks like you have a table for each of the elements....and so what you
need is a Transaction Table that would be more or less a cross references the
key fields of your other tables - plus - with a new column field that maybe
is just In or Out and probably a date column .....

Transaction Tables records start with Stock IN then add new records for
Stock is Out to a customer and then a new record when back IN....

you can then sort by product by date the Ins & Outs and to which customer....

This is just one of many ways to attack this problem and others will
probably also have good advice....we've done alot of inventory and I've seen
this demo situation before...gets a bit tricky when customer decides to buy
and keep the demo unit....