AnsweredAssumed Answered

select specific item from a portal

Question asked by david583 on Jun 3, 2009
Latest reply on Jun 4, 2009 by david583

Title

select specific item from a portal

Post

I have a customers table and an equipment table. 1 customer has many equipment.

I have a report that lists all customers and I'm trying to show only "Olympus E-1 Camera" from equipment in a portal.

I have managed to sort the portal so that the camera is at the top and is the one displayed, however if no camera is with that customer it will show whatever is in the top of the list.

How can I do this so that it gives me a blank return if no camera is present? I have tried many ways and so far the portal method gives the best result except for these other items.

Outcomes