Related Records and Repeating Fields

[charper]

I have a Product file and an Orders file.

In the Orders file I'm storing a list of product names (from the Products file) in a repeating field. From the Orders file layout, I want the user to be able to press a button/script that takes them to a Product file layout that displays the entire record for any of the product names in my repeating field. How can I do this?

If I just have the button execute a Goto Related Record command (Orders:Product Name = Product:Product Name), I always get the product record for the FIRST repetition of this field.

[ZuperZZ]

(me again)

First of all I should try to avoid the use of repeating fields. They carry a lot of complication.

I would do this (I