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.)

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.