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 Into Multiple Tables

RalphLA
in Importing & Exporting

Featured Replies

  • Newbies

I have an Excel file with Personal Contact Info I would like to import into my Filemaker database. However, in Filemaker, the Personal info (e.g. First Name, Last Name, etc) is stored separately from the Addresses, Phone, Email records. The tables are related via a unique identifier.

Whenever I try to import the data, I don't see an option to map the fields to different tables. It only lets me select the table in the current view.

Does anyone know how to do what I'm trying to achieve?

Thanks!

You can not import to two different tables at the same time. You have to import them into each table separately. Another option is to import it into a temp table and then script it to create the records and its corresponding child records into each table with a loop script.

Create an account or sign in to comment

https://fmforums.com/topic/66118-importing-into-multiple-tables/
Go to topic listing

Important Information

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

I accept

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.