hhuang

Hi John, I answered my own question. Moving forward Thanks! -Helen

Hi John, Thanks so much for your response. There are a few basic things that I don't understand in your explanation however (I am new to FM). How do I access the portal row number? And how do I make the script look at each row (I only know how to make it look at the first row)?

Hi, I have two Qs about portals in a self-joining relationship: 1) How can I omit the record "itself" from its own portal? 2) It seems that the portal only looks at the first related record. Is this true? If so, this self-joining relationship is not as helpful as I would have hoped (it can't relate one record to several others; it can only relate one record to one other record? And the one other record is always the same?) -For example, I have set up a self-relationship for the purpose of de-duping. Thus, the "Bothnames" field in record A is matched with all other records with the same "Bothname". The portal in record A shows record A (this is the undesirable situation that I am referring to in my first question), and two other records with the same "Bothname". When I use a calculation field to make a comparison between "Address" and "::Address", the caculation always uses the first record listed in the portal. How can I use the self-relationship to compare to more related records than just the first? I hope that makes any sense. Thanks for your help.