Jump to content

display portal fields based on ID of current customer


titanium

This topic is 5563 days old. Please don't post here. Open a new topic instead.

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.

Link to comment
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.

Link to comment
Share on other sites

This topic is 5563 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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