So I'm transferring an old filemaker database to MySQL and some repeating fields are causing me some problems. I've read that the ODBC standard support those fields, only when their types is "Text" and that each repetition is concatenated with a certain delimiter (see page 47 (PDF)). However, I just can't reproduce this. All I get is the first repetition.
If I export the database to the .csv format, the fields are correctly concatenated, so I'm not completely stuck, but if possible, I'd like to be able to obtain the same result with the ODBC connection. Thanks!
Best Answer
With JDBC and Filemaker 12 I can access the repeating field using brackets as it was table beginning with index 1. It should be the same in ODBC. Of course I recommend to normalize but it can help to know there is other options.