Inventory form

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
 
B

BruceM

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.
 
P

Powderfinger

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.
 
Top