Add subform record on data import
I have some data pulled from analytics. I also have a "Projects" form with an "Assignments" subform linked to the "Assignments" form (not a blank form). Now when I edit a Project record, I can add new assignments manually and it will add the records in the "Assignments" form automatically BUT I am not able to link those two in the subform when I pull data from analytics.
I can do this:
- insert into Projects
- [
- Project_Name = "Project 1";
- ]
- insert into Assignments
- [
- Assignee = "Jack Wright";
- ]
but I didn't find a way to link these together so that when I open the Project the assignments linked to that project are automatically populated, as if I added them manually through the Project form.
Is this possible or am I trying something that fall under the limitations of creator ? Should I use a blank form instead ?