Hello

I have a photo ID database that we use to locate our customer Identification cards.

In some cases when a dealer shows up there are as many as 10 different buyers all with the same Buyer ID number. I would like to find a way to display all the photoID pictures when we look up their buyer number and then be able to click on the picture that matches the person and have filemaker correctly enter threir name fromn a lookup.

So to summarize

a buyer arrives. They give us their "buyerIDnumber" we enter that number and filemaker would look up a person whose picture is in the table " photoID" but I need the others with the same buyerIDnumber - pictures to be displayed and then be able to click on the matcching one and have it give a name to the person I am talking with.

Different buyers have the same ID number? That sounds like a bad idea. In any case...

Put photoID into a portal with 10 rows, based on the relationship from buyerID to buyerID. (Or 10 identical portals with 1 row, each starting with a different iteration... that clever FM7 trick.) Attach a button to photoID that links to a script with the following step:

Set Field ( DestinationField , BuyerID::BuyerName )

Jerry