Hi, I have a portal for users to input data. After users input the first two fields, I want to do a search to see if there are any existing records in the portal have the same values in these two fields and then highlight the existing record for users. My problems are:

1. I don't know how to highlight something in portal.

2. How do I trigger the script when user leave field two? Currently I am using FMP 9, I heard FMP10 can do that but I don't plan to update at this time.

Thanks in advance for your help.

Ok, I know how to highlight a row now. The way I plan to work on this problem is to setup a script and add a new field called highlightMe in the portal table. Every time when the first two fields of a new row are added (Field A and AA) to the portal, I will loop through the whole portal. If I find an existing record in the portal with the same fields A and AA, I will change this record's HighlightMe to some number so the conditional format will work. I feel this is definite not the best way to handle it. Can self relationship help here? How can I change the value of HighlightMe field by setup a self relationship?

Thanks.

You can trigger it by using a variation of these technique

http://www.nightwing.com.au/FileMaker/demos8/demo806.html

http://www.filemakermagazine.com/videos/highlighting-portal-rows.html

http://www.filemakermagazine.com/videos/highlight-record-row-in-list-view.html