I have a proposal system that uses a repeating field for the lines of the proposal. Unfortunately, I can't change that at this point. I am trying to install a portal that has a relationship to one of the columns (product model). I would like it to relate to whichever line of the repeating field is selected. Any idea how to do this? It only relates to the first line.

You could put a button on the portal that does Set Field (globalID, itemID), and make the new portal based on that relationship.

Thats an idea, I am trying to make it auto as the portal is to show notes and requirements for the line in the proposal (i.e. this item also requires part 1234)

"Make it auto," could you be a little more vague please? Hmmm, I'm reading more carefully - you want to click on a line of a repeating field and have the portal relate to that, ah, I think I had it backwards. Well, put the button next to or on top of each line of the repeat. You will need a separate button and script for each repetition.

ok, some details....

The database is a proposal system. It has 9 repeating fields 300 lines deep. One of the fields is called 'model' it is a pop up list from a related database 'products'. Basically the other 8 fields are lookups from 'products'. In 'products' there is a field called 'required' which contains important information such as the product requiring another part to properly function, etc. The field is 4 lines long and I don't want to display it on each line. My though was to create a portal with the 'required' field in it. The problem was how to create the realtionship to the 'model' repeating field. I had originally hoped that when I selected one of the repeating 'model' fields it would use that info in the realtionship. It did not, and only worked off of the first line. I changed my though and added a calculation field called 'rep'. 'rep' is automatically calculated to equal 'model' of the repeition I select. This works fine. But now I changed my portal relationship to work off of 'rep' and it does not update at all. Getting frustrated! Any thoughts?

"'rep' is automatically calculated to equal 'model' of the repeition I select. This works fine. "

Uhh?

Shouldn't worka s fine as this calc cannot be stored. So...no valid relationship.

Why not use a calculation stored in the related file which extract each of your repeating values in a Multikey (c_Mkey = GetRepetition(field,1) & " " GetRepetition(field,2)& " "& GetRepetition(field,3) & " " & GetRepetition (field,4)

or simply the newest function of FM, GetRidOfRepetition ( )