Hi all.

I'm sort of new to FileMaker.

I'm trying to at a second level of "find" to a portal window based upon a pop up list or a another portal list.

I have a relationship where ClientID shows me related records for all Order Numbers for that ClientID. But I want a way to choose an Order Number by clicking and the details of that Order Number show up in a portal of related records.

I guess this is sort of like being able to look at the details of a client's invoices by choosing the invoice number.

I've taken a screenshot to help explain this.

http://www.studyusamagazine.com/downloads/Files/FM_Screenshot.gif

I've been scratchig my head on the for hours and any help would be much appreciated.

thanks,

John Wells

Hi,

What you could do is create a global field 'gOrderSelected' and create a new Table Occurrence called 'FilteredOrderDetails'.

Link the orderID in that new TO to the gOrderSelected field.

Now, the portal appearing on the right side would use that new TO and you can switch from one order to another with a script attached to the Left portal rows which would be.

SetField[MyTable::gOrderSelected;MyLeftPortalTO::orderID]

Hi Ugo DI LUCA,

First let me say that I love Paris and am trying to figure out a way to move there in the next couple of years. When I am there I always feel like I am home.

Thank you so much for your help. I'm almost understanding this, but not quite. I'm confused where the global field should be created and I'm also not sure aobut the need to create a new TO. I have tried a few different things along the lines of your suggestion, but I can't make it work. I've upoaded another screen shot of the tables I am working with.

http://www.studyusamagazine.com/downloads/Files/FM_Screenshot-2.gif

Merci!

John