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 to Separate Records with Multiple Repeating Fields

CMothorpe
in Importing & Exporting

Featured Replies

  • Newbies

Please help. I need to export records as separate records, but I have multiple repeating fields. How can I best do this?

Perform a find for the records you wish to export.

Create a new FM Database with the fields you want.

Within the new database, import the records from the original db, select the option "splitting them into seperate records".

I had a similar question (see below) and tried the above solution. The problem is that you then end up with a bunch of duplicate records. FOr example, mine is a HR Database. If employee "Smith" had a repeating field with 5 repetitions then I ended up with 5 records for Smith. Is there a solution?

Thanks for your comments.

First of all: What exactly do you want to accomplish? What should be the end result?

Create an account or sign in to comment

https://fmforums.com/topic/1419-export-to-separate-records-with-multiple-repeating-fields/
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.