portal is needed to display a range of data from another table

[xxx202xxx]

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, 2010 by Guest
Trying to make it clearer

[dayzrespite]

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...

[xxx202xxx]

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, 2010 by Guest

[dayzrespite]

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