Inventory form

  • Thread starter Thread starter K
  • Start date Start date
K

K

Hello everyone...
I would like to know if its possible to create a form which will be a
multiple item form... of a table Products which has the name, price,
quantity, date as fields... and then somehow by a button relate it to
a client and store in some kind of buyers history...

the problem would be also with the relationship..but how its possible
to create something like an inventory
 
The place to start is by creating tables and relationships. If you are
looking to create a listing of vendors and the products offered by each one,
you would need a vendor table and a product table related one to many, with
a form/subform as the interface. A button is not needed to created the
relationship, or to link products to vendors.
Creating "something like an inventory" would depend on just what you need to
do. Details needed.
 
The most popular database in the civilized world has four tables:

1)Product Table - a list of your products in your inventory with a primary
key of ProductID
2)Customer Table - a list of customers with the primary key CustomerID
3) Invoice table- A list of your sales with primary key InvoiceNO. This
table also includes the field CustomerID
4) Invoice Detail Table - Includes the fields InvoiceNO and ProductID .

After you have created these tables , open up your relationships window and
create the relationships between the tables which have common fields.

You are well on your way.
 
Back
Top