Demonstration Stock Tracker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VT - 23 Oct 2006 11:06 GMT

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.

Reply to this Message

Wayne-I-M - 23 Oct 2006 13:37 GMT

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

Signature

Wayne
Manchester, England.
Enjoy whatever it is you do

> Hello,
>
[quoted text clipped - 15 lines]
>
> Many thanks.

Reply to this Message