June 23, 201015 yr Hi, I am pretty new to Filemaker so please be patient with me:) My problem - I have a layout which shows multiple records in form view, where each record consists of multiple related tables (Events & Persons). I can obviously type an entry directly into the layout and it populates both tables. So, how do I do this as an import since the import only allows me to import to one table at a time. I am currenlty able to do this but it takes a lot of manipulation since I have to create the data first in the "persons" table in order to get their "key" and then add that key to a new import file to populate the "event" table with. What techniques can be used to automate this? I have heard mention of creating an import table and somehow looping through this table to populate my layout. Is this right? and if so, where can I find a more detailed explanation of doing this. I hope you can make some sense of this rambling.
June 23, 201015 yr "So, how do I do this as an import since the import only allows me to import to one table at a time." That is correct. So two imports. But it would be probably be a good idea to provide more information. Seems likely, for instance, that you could end up with multiple records for the same person; or multiple copies of the events.
Create an account or sign in to comment