Jump to content
Sign in to follow this  
titanium

display portal fields based on ID of current customer

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.