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.

Export records from related table

Charles Fowler
in Importing & Exporting

Featured Replies

I have a number of records, one for each student - each has a number of records related to it in another table, the six or seven courses they take.

In version six, when I exported from the student table, and included fields from the related table of courses, the export pulled all the records from the related record. Now, in seven, I'm getting only the first of the related records.

How can I tell the export that for each record I want to pull all the related records from the other table?

Many thanks,

I'm having the same problem. I've doen some teting, and found that if you close the database and reopen it, you can get all the related records. BUT, if you sort the records first, you only get the first related record. Once the damage is done, it is irreversible, even if you unsort. You have to close the file and reopen it. Smells like a bug to me!

  • 1 month later...
  • Author

A belated thank you to Cable for that post back in November - it's been a huge help, and saved a lot of trial and error.

I wonder if anyone has heard from FileMaker about aknowledgement of the problem? Or perhaps it's not a fault, it's a FEATURE!! Argh.

Thanks again,

Create an account or sign in to comment

https://fmforums.com/topic/28052-export-records-from-related-table/
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.