Setting a global field from a repeating field

[ace_bird_dog]

After reviewing many posts here, I now understand the limitations to using repeating fields, I'll know better next time. I have been banging my head against my monitor all day trying to figure this out, please help.

I have three repeating fields that represent information about a product: Item #, description and color. I need a global field to display what the Item # is for that line regardless if the current active field is Item #, description OR color.

Thanks a ton.

[-Queue-]

You can't do this with a global, unless you put transparent buttons over each repetition that trigger a script to set it with the current repetition's item number. In this case you would need 15 scripts, one for each field, to

Set Field [global, GetRepetition( Item#, {therep} )]

Go to Field [whateverfield-{therep}]

where {therep} is the hard-coded number for that repetition.

This will require disallowing access to the field, which means you will only be able to click on a button to enter a particular field's repetition and not tab through them.

[ace_bird_dog]

I had that as a test scenario but ultimately ruled it out for being too ugly and I need tab access to the fields for data entry. In the real database, I have 30 repetitions of the fields so I'd need 90 scripts. If I were to use something other than a global, would that work?

[-Queue-]

Nope. A calculation using Status(CurrentRepetitionNumber) wouldn't recalculate until you exited the record, so it would be useless. Your best option is to convert your repeating field solution to a relational one.