I was hoping someone could explain where I'm going wrong.
I have an excel file with 2 tabs relating to parent and subform.
1) "my Parent record" (named exactly the view name)
With an added column with the Subform field name with records = 1 2 3 4 etc
2) "my subform record" (" ")
with added column with REC ID linking relating to above 1, 2, 3, 4 etc
I then go to creator then to the parent view - more settings, import excel with subform data enabled
I can see both sheets on the import wizard. I first select the parent sheet. I select what tabs go where on the parent sheet
I then select the sub record sheet and relate it's fields to the "related fields" available from the drop down list.
When I go to save, it does not add any records to the parent view, it only adds sub records????
What field should the REC ID relate to as its not explained in the forums.
Thanks
Pete