Alternatives to Repeating fields??? Help

[synergy]

What is the best alternative to using repeating fields,

whether it be in a single file or multiple file solution?

My first issue is with a online form that requires pull downs to facilate multiple scanning within an order ((for the quote) ( on the html side is there perhaps a better option as well))

i.e. 5 scans at 5x7 in 4 color process, 12 scans at 16x20 in duo tone.? ( in this case there is a field to enter amount then the size and then the process. (The last two are both pull down menu's on the html form, as well as the FM5 db.)

[CaelC]

I'm not sure I understand exactly what you are asking but ....

Usually the best way to get rid of repeating fields is to use a related Line Items type of file to hold the information. You can display related records (line items for example) in your current file through a portal.

You can not run good reports easily on repeating fields.

Hope this helps,

Cael.