Hey all, I have a small conflict ;
I have 2 tables. First table is " All movie information " - with 20 detailed columns I populate in my form. In my subform I only created 3 columns from the 20 to capture specific data which I would like in my Second table " some movie information "
So my main purpose is to not duplicate data entry, instead have one unique record in the First table and subrecords for that one unique record in my second table using a subform
I established a relationship through " ID " between All movie information table and some movie information, I am only capturing all data in First Table when filling out my main form, but the second table is blank with the specific information I need, even though I have a subform which does populate as well specific data I ask, its just not translating it to the 2nd table.
Please help any feedback would be appreciated
I have 2 tables. First table is " All movie information " - with 20 detailed columns I populate in my form. In my subform I only created 3 columns from the 20 to capture specific data which I would like in my Second table " some movie information "
So my main purpose is to not duplicate data entry, instead have one unique record in the First table and subrecords for that one unique record in my second table using a subform
I established a relationship through " ID " between All movie information table and some movie information, I am only capturing all data in First Table when filling out my main form, but the second table is blank with the specific information I need, even though I have a subform which does populate as well specific data I ask, its just not translating it to the 2nd table.
Please help any feedback would be appreciated