I have a layout called "Assets" where I would like to insert a portal. The portal information is coming from another table called "Service". However, the data that I would like to see in this portal is only the data that relates to the asset record that is displayed or searched on.

For an example: Laptop 13 is an asset, so when I select laptop 13 from the "Asset Table", I want to see all the data that is associated with that laptop. That part I have manage to complete using fields. In addition to that information I wanted a portal that would show all of the service tickets that pertains to laptop 13. Instead of the portal I have created where it is showing "all" service tickets, regardless of the asset.

Edited January 13, 201016 yr by Guest
Trying to make it clearer

If I understand correctly:

You are on the Assets Table, and would like to see only the related Service Tickets.

If that is so: begin with your relationship. Each asset has an ID field that is unique to the asset. The Service Ticket also has a unique ID, and must also have Foreign Key that will be used to relate that Service Ticket to the Asset.

_pk_asset = _fk_ticket

Then place the portal based on the Service Ticket TO on your Asset based layout.

Hope that makes sense...

Thanks for the push. After reading your response it, clicked. I already had the fields, I just needed to create the correct relationship.

Edited January 14, 201016 yr by Guest

Glad you got it working, if you need anything else, feel free to ask, welcome to the forums. -)