I have a problem in FileMaker 9 I'm scratching my head over that I'm sure must have a simple solution. I have a table with customers that is linked by the customer id to a table that lists requests the customer has submitted. Each request has a request id.
I have a layout that shows the customer details on the left of the screen and a portal that lists the customers requests in form view on the right of the screen. If I scroll down in the portal I can see all of the requests a customer has submitted.
When I do a find on a request id in the portal it returns ALL requests starting with the first in the list. What I'd like it to do is to scroll down to the actual request I'm searching for rather than take me to the first request in the list. Is there a way to do this?
I've tried utilising a script to do a "Go to Portal Row" but how do I establish what row a particular reqest id is in? Or is there a better way to do it?
Any advice gratefully received.