Copying data from subform to main form

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I am trying to create a very simple MRP data base for my business.
In doing so I need a data base that contains my poduct numbers and each of
these product numbers is linked (somehow) to a purchased part material list
data base that holds which purchased parts are used for a given manufactured
product number.
I planned on creating a data base of all purchased parts and then use this
in a subform manner within a material list form for a given manufactured
product.
The problem I am having is that when I open the material list form and
scroll through the purchased parts subform for the part I want, I can't seem
to get the material list form to accept the input from the purchased part
subform. Oh I can display the selected item in the material list main form,
but I can't seem to get the main form to accept it and move forward for a new
purchased part to be selected and enterd.
 
Are you saying the products are manufactured from purchased parts, and that
you want to be able to populate the parts list for a given product? If so,
a product may consist of many parts, and a part may be used in many
different products, I expect. If so, you need three tables.

tblProduct
ProductID (primary key, or PK)
ProductName
Description, etc.

tblPart
PartID (PK)
PartName
Description, etc.

tblProductPart
ProductPartID (PK)
ProductID
PartID
Quantity

If the information about a Part includes Manufacturer you will need a
Manufacturer table too.

Build a form based on tblPart, and populate it with all the Part information
you have.

Build a main form based on tblProduct, with a subform (Continuous view)
based on tblProductPart. On the subform, bind a combo box to ProductID.
Use tblPart as the combo box Row Source. When you select a Part from the
combo box it will be added to the Part List for the product in the main
form.

This is just a sketch, since it is not entirely clear this is what you
intend. If it is not, please clarify.
 
Back
Top