use of "Go To Related Record" with repeating fields?

[mzimmers]

Hi, all -

Is it possible to get to record "B" via a repeating field in record "A"? I'm currently doing this with a global variable as an intermediate step, but it feels like kind of a hack. Is there a smoother way to do this?

Thanks...

[Søren Dyhr]

Yes via Go to related record (Show Only) but if the repeating field contains several value will you get a found set of records - one for each key value in the repeating field.

But chances are that you barking up the wrong tree, repeating fields should only be utilized for inner mechanics in a database, never for storage of user entered values.

I've made you a template that shows how to use repeating fields as key-value for getting to a record in another table occurrence (well it's another table except when selfjoining)

--sd

reptest.zip

[mzimmers]

Thanks for the response. As it happens, I did a bit of re-design and eliminated the repeating fields altogether. I'll try to avoid use of them wherever possible, based on advice of others here...

mz