Triodes Posted October 20, 2004 Posted October 20, 2004 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!!!
transpower Posted October 20, 2004 Posted October 20, 2004 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).
Triodes Posted October 20, 2004 Author Posted October 20, 2004 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
-Queue- Posted October 20, 2004 Posted October 20, 2004 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.
Triodes Posted October 22, 2004 Author Posted October 22, 2004 Hi Queue, Ingenious!!! thanks.... why didn't I think of that Jim
transpower Posted October 24, 2004 Posted October 24, 2004 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.
Lee Smith Posted October 24, 2004 Posted October 24, 2004 Isn't this a v7 file? A link would be helpful. Lee
transpower Posted October 24, 2004 Posted October 24, 2004 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.
Recommended Posts
This topic is 7411 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now