Portal with Relationship to Repeating Field

[Edward Newman]

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.

[Fitch]

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

[Edward Newman]

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)

[Fitch]

"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.

[Edward Newman]

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?

[Ugo DI LUCA]

"'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 ( )