G
Guest
I am creating a new dbase that will be used similar to a bill of material
(BOM). My problem resides with making the two primary Tables to interact
correctly together. I have created a main data entry form and a Subform that
will be used inside the main Form. The main form will be used to select
parent item numbers and the subform will be used to assign multiple component
items to the parent number. Both the parent items and the component items
have their own separate tables. I am creating my forms directly from the
Tables. The parent table has a component field that is linked to the
component Table. I have the parent form functioning properly and allowing me
to assign multiple components to the parent item number, however these
component numbers are not being saved when I return to the record number in
the form. Please help! Am I way off base or should I find a sample dbase to
use instead? Thank you for any assistance that anyone can provide!
(BOM). My problem resides with making the two primary Tables to interact
correctly together. I have created a main data entry form and a Subform that
will be used inside the main Form. The main form will be used to select
parent item numbers and the subform will be used to assign multiple component
items to the parent number. Both the parent items and the component items
have their own separate tables. I am creating my forms directly from the
Tables. The parent table has a component field that is linked to the
component Table. I have the parent form functioning properly and allowing me
to assign multiple components to the parent item number, however these
component numbers are not being saved when I return to the record number in
the form. Please help! Am I way off base or should I find a sample dbase to
use instead? Thank you for any assistance that anyone can provide!