select specific item from a portal
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.