Repeating Fields and extra space

[MartinGibbs]

Hello, I've got a repeating field big enough for 30 items. Those items are coming off of a select menu from a web page. Now, since I have 30 items, every time I show that field on a format field with the [FMP-Repeating] stuff, I get the full space for 30 items.

Would anybody have a script on how to chop off those extra spaces if they are blank? Would I test each line? Or could I loop through....

thanks!

[Vaughan]

You don't need a script. You need to convert your system to a related database, and display the related fields with a portal.

Trust me, you'll love it!

[Anatoli]

Yes, the only question, which makes sense with Repeating fields, is:

How Do I Convert Those Dreaded Repeating Fields to Related Database Design?

[Rigsby]

Not a big problem: Just do an export from your main database, selecting the repeating field, then split repeating fields into separate records. You just need to make sure that you export a key field at the same time.

Rigsby