Create one-to-many on import
I have a spreadsheet that has 4200 rows of information real estate property information. each row has information about the property and information about the owner of that property.
I need to import this information into my Creator DB. Each owner can own multiple properties. I have created two forms in Creator, one for Owners and one for Properties.
How do I import the data into Creator while maintaining the relationship between the Owner form and the Properties form?
I know I could import all the data and use an "Import" field in the Properties form to manually relate each property to its owner, but this is not posssible with 4200 entries.