R
Rhonda
Here's some information on what I'm trying to do. I own a greenhouse and I
want to keep data on inventory, costs and sales. Be able to keep databases
on the cost of supplies and be able to pull them together to determine the
costs of pots, flats, and baskets. I have set up 4 databases
Expenses (contains items not related to sell cost of plants, ie utilities,
repairs,etc.
Seeds and Plugs (contains product id, product name, product description,
cateory ID, units in stock and unit cost
Supplies (contains category id, product name, product description, supplier
id, units in stock, unit price, product id...there is no information in this
field at present)
Tags (contains tagsid, product name, units in stock, unit price, product id
(no information in this field at present)
I let Access choose the primary key and it set up an automatic number is not
the same in each table for the product name.
How do I set up primary and relationships that will link all the tables
together in order to price and inventory sales?
Thanks
Rhonda
want to keep data on inventory, costs and sales. Be able to keep databases
on the cost of supplies and be able to pull them together to determine the
costs of pots, flats, and baskets. I have set up 4 databases
Expenses (contains items not related to sell cost of plants, ie utilities,
repairs,etc.
Seeds and Plugs (contains product id, product name, product description,
cateory ID, units in stock and unit cost
Supplies (contains category id, product name, product description, supplier
id, units in stock, unit price, product id...there is no information in this
field at present)
Tags (contains tagsid, product name, units in stock, unit price, product id
(no information in this field at present)
I let Access choose the primary key and it set up an automatic number is not
the same in each table for the product name.
How do I set up primary and relationships that will link all the tables
together in order to price and inventory sales?
Thanks
Rhonda