I am trying to redo a badly organized database, without completely losing all of its data. Right now, I have ten separate repeating fields of session dates for each client number. I have figured out how to combine them into one large repeating field via calculation for the purpose of exporting, but I can't figure out exactly how to proceed to my end goal from here. Since each session can be identified by Client Number and Session Date (no more than one session per client per day), I am trying to export each of the dates in the large repeating field along with the client number associated with each date, so I can later import this information into a new separate Sessions table, with a separate record for each Client Number/Session Date entry. However, when I try to import, it will only import the first session date of each client, rather than all of the dates.

Edited March 24, 201015 yr by Guest

Don't export; just import. FileMaker allows for splitting repeats when importing.