Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Importing Excel to layout with mutliple tables

Featured Replies

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.

"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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.