display portal fields based on ID of current customer

[titanium]

Hi,

I think this has been covered in the topic

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

but as a beginner im not 100% sure it applies to what im doing/ i dont fully understand the structure.

I have a customer record and that customer has several Hydrants. Each hydrant is inspected anually. On the hydrant detail layout (which displays all that hydrants specifics) i want to display a portal of all previous inspections related soley to that hydrant. (then i will be able to review previous years inspections as needed)

I have a portal that works but of course it displays all inspections from all hydrants, not just the one which im looking at. So, I appologize if this is exactly what the other topic is exploring, but perhaps someone is able to clear this up for me.

[comment]

I don't see the connection to the referenced thread.

You should have three tables: Customers, Hydrants and Inspections, with the following relationships between them:

Customers::CustomerID = Hydrants::CustomerID

Hydrants::HydrantID = Inspections::HydrantID

Once you have that, a portal to Inspections placed on a layout of Hydrants will show only the inspections for the currently viewed hydrant record.

[titanium]

Hi,

Thanks for the rapid reply. Sure was a much simple solution than i was looking for! Looking at it now, i almost had it right, just had the portal pulling from the wrong table.

Your advice is very much appreciated.