E
Emily
Hi Everyone,
I am sure this has been asked 1,000 times, but I can not seem to get
anywhere. I am making a database for my Jewelry Store. I have two types of
inventory, Part and Finished Products I have set-up tables and started on my
forms. My Tables are: (leaving out fields that do not matter for mt
questions)
Finished_Inventory
ID
Vendor
Quantity
etc...
Parts_Inventory
ID
Vendor
UOH(Units on Hand)
etc...
Finished_Inventory_Detail
Finished_Inventory_ID
Parts_ID
Quantity
Cost
etc...
I use parts to make finished items and well as purchase finished item. On
my finished inventory form I have a sub form to enter in any parts I may have
used. My problem is making Access take the parts I have used in the Finished
Inventory Sub table out of the Parts Inventory automatically.
I will also set up a Customer purchase table and I assume that I can set it
up the same way to take out of finished Inventory.
My next question is if I purchase X more of item A can I just go into that
item and adjust the quantity and cost with out have to set a vendor purchase
table.
I am learning still so please go easy on me. I thank you in advance for all
your help.
Emily
I am sure this has been asked 1,000 times, but I can not seem to get
anywhere. I am making a database for my Jewelry Store. I have two types of
inventory, Part and Finished Products I have set-up tables and started on my
forms. My Tables are: (leaving out fields that do not matter for mt
questions)
Finished_Inventory
ID
Vendor
Quantity
etc...
Parts_Inventory
ID
Vendor
UOH(Units on Hand)
etc...
Finished_Inventory_Detail
Finished_Inventory_ID
Parts_ID
Quantity
Cost
etc...
I use parts to make finished items and well as purchase finished item. On
my finished inventory form I have a sub form to enter in any parts I may have
used. My problem is making Access take the parts I have used in the Finished
Inventory Sub table out of the Parts Inventory automatically.
I will also set up a Customer purchase table and I assume that I can set it
up the same way to take out of finished Inventory.
My next question is if I purchase X more of item A can I just go into that
item and adjust the quantity and cost with out have to set a vendor purchase
table.
I am learning still so please go easy on me. I thank you in advance for all
your help.
Emily