Hi,

I'm workig on a dB solution and want to use repeating fields for the application at hand. I normally make a seperate dB which holds a single record for each line of a quotation/invoice/whatever, but this is kind of redundant for what I want to do now.

I want to copy selected info from different records in file X into a repeating field in a single record of file Y. So far so good, no problem in doing that, but...

In the layout of the new dB I only want te repeating field to show about 5 lines/values (for example), yet this field could in actuality contain 20, 30 or 100 values. My problem is that I can't find a way to scroll through the repeating field values like in a table or portal.

Does anyone know if this is at all possible and if so, how it can be done? I've tried the help files (grrr) and this forum but can't find any hints.

Thanks!!!

SFASIK, it's not possible. HTH. Of course, you can just show 5 (Format | Field Format), but you can't scroll beyond that (even with setting to show scroll bar).

Hi,

Bummer... I guess I'll have to make an extra db to hold a record for each line and just use a portal in the main file.

jim

You could use a global repeating field and scripts to set the repetitions with the next five reps, previous five reps, etc., using arrow buttons for navigation.

Hi Queue,

Ingenious!!! thanks.... why didn't I think of that

Jim

A neat illusion. Another idea I just came up with: use The Shadow's custom matrix functions to create a vector equal to the repeating field (one vector element equals one repetition); display the vector in a scrolling text field...but there may be a problem with the required semicolons. If so, then why not just set a text field such that each line is one repetition, with a paragraph symbol in between...tested, works.

Isn't this a v7 file?

A link would be helpful.

Lee

Lee:

Yes, the matrix functions are for 7. Hence, for 6, you could just use a scrolling text field, as I stated. I think that not having scroll bars built-in for repeating fields is a defect in FMP.