Okay my FileMaker friends--I'm willing to listen to the anti-repeating fields answers I will get, but I must ask this question. Is there a way to import repeating fields from a text file? The file contains two fields: member_number and designation. I may have more than one designation for a member.

The twist, and why I don't want to use related files if at all possible, is that I'm creating a run-time CD. It's taking forever for FM to open all the related files, just to display one field from each file. I have 5 or so different files that I would like to experiment with making repeating fields and see if that speeds up opening the files. Also, I'm thinking it would be a total pain to try to combine all the files into one related file, but may be able to do that as a last resort.

BTW, I'm using FMP5

Any input would be helpful, including any other ideas about how to speed up opening of related files...

THANKS!

[ December 12, 2001: Message edited by: mr ]

Each value in a repeating field is separated by an ASCII 29 character. You will have to insert these before you import.