I have a 3 tables:

work orders

vehicles

parts

I have a layout with two portals on it:

one with work orders which matches a certain vehicle (Only shows work orders for the vehicle indicated)

one with parts for the corresponding work order

(or at least thats what I would like)

right now I have 3 work orders showing for a certain vehicle). Can someone point me in the right direction as to when I click on a work order in one portal ONLY the parts used for that WO populate the other portal? Sorry if none of this makes sense. I'm sure there's an example on here somewhere that shows how to do this, but I can't find it! Thank you in advance!

You'll need a global field in the Vehicle table, let's call it gWO because it seems that the layout with the portals in based on a Vehicle table occurrence, right?

When the user clicks the Work Order in the portal, you set the gWO global field to that WO_ID.

The parts portal uses a new relationship:

Vehicle:gWO = Parts::WOID

I'll see if I can find an example.

Ahm, version 11? Filtered portals? Variables?

http://fmforums.com/forum/showtopic.php?tid/214676/

I don't do filtered portals the FM11 way, call me old-fashioned. I work with too many FM10/FM11 mixed environments.

Here's an FM10 version.

ViewGrandchildren.fp7.zip

I don't do filtered portals

I do - call me whatever you will. :

ViewGrandchildren11.zip

You guys are funny. :

I do - call me whatever you will. <img src='http://fmforums.com/forum/public/style_emoticons/default/crazy.gif' class='bbc_emoticon' alt=':' />

Hi Comment, I've downloaded the attached files and tried to study it. For some reason I was expecting to see something in the filtered portal but they are blank for both parent records. Also I'm interested in your calculation in the filter portal dialogue box with $$ etc. Does this calculation differ from any other such as when defining a calculation field for example because it's for a portal?

I was expecting to see something in the filtered portal but they are blank for both parent records.

They will be blank until you select a child by clicking on one in the leftmost portal.

Thanks for the explanation. I like the use of a button and conditional formatting, gives it another dimension. I don't understand the script behind it, set variable etc but I hope to in time.