Demonstration 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]

Hi

You could create a form based on a query (from the customers table). On to
this form have 2 tabs with subforms showing orders and returns. The orders
subform would be based on a query to work out costs etc and the retuns could
be linked to your stock table via a query to always be able to give you up to
date info on stock levels.

The invoice would be based on the customers query (but actioned from the
orders tab subform. As an order is made you could produce the invoice
(report based on the order).

Just a point - this is one of the most common uses of access db's and so
there are many templates available that you could easily alter to your own
requirements. Check out the NorthWind DB or go to
http://office.microsoft.com/en-us/templates/CT011366681033.aspx
where you will find a ready made Customer orders database. Not sure where
you are from but it's very american so if you are anywhere else it would need
changing to fit your own location but it's not a big job.



Hope this helps