L
Liz
I have a list box in my main form for different assemblies. When the user
selects one, I want the subform to have all the related part names and
numbers for that assembly. Right now I have three tables.
Part List - contains the part names (PK), part numbers (PK), and assembly
name
Assembly - contains the assembly names (PK)
Input Log - contains fields for part name, part number, and additional
columns for descriptions I want the user to input
I have a one to many relationship between assembly and parts list. I also
have a one to many relationship between the parts list and input log. I
would like to have the subform have all the columns the input log has and be
filled with the part names and numbers that are related to the assembly in
the main form. When the user types in new data I want it to write to the
Input Log. Any suggestions? I'm very new to this so any help would be
great. Thanks!
Liz
selects one, I want the subform to have all the related part names and
numbers for that assembly. Right now I have three tables.
Part List - contains the part names (PK), part numbers (PK), and assembly
name
Assembly - contains the assembly names (PK)
Input Log - contains fields for part name, part number, and additional
columns for descriptions I want the user to input
I have a one to many relationship between assembly and parts list. I also
have a one to many relationship between the parts list and input log. I
would like to have the subform have all the columns the input log has and be
filled with the part names and numbers that are related to the assembly in
the main form. When the user types in new data I want it to write to the
Input Log. Any suggestions? I'm very new to this so any help would be
great. Thanks!
Liz