Yep, this is an inherent limitation to repeating fields. Don't use them. Use a table of related records, one in place of each repetition instead.
Many thanks for your reply, I kind of gathered from reading some of your other posts about this, but I have absolutely no idea how to change them to tables of related records? Could you point me somewhere I can find this out?
Simply define a new table with the needed fields. Include a match field to your original table and define your relationship. If you don't already have an auto-entered serial number field in your original table, add one and use Replace field contents to update all of your existing records to have serial number values. This is the field to use as a match field to your new related table.
Then use import records to import the data from your original table into the new table. (It'll look like you have to import records from another file, but just follow the steps and select the file you already have open as the file from which to import your records.) When you import the records map only the repeating field(s) and the serial number field to corresponding fields in the new table. When you click the Import button after mapping the fields, you'll get a small dialog appearing with an option to split data from your repeating fields into individual records. Select this option and import your records.