Hi, I am working on a database of exhibitions (with FM Pro 15). All exhibitions are on one table. All artworks on another table. Each exhibition has one or more artworks. From the table of artworks I would like to create a selection (find) of one artwork for each exhibition. For this selection of artworks I am planning to make a separate layout.
I have tried with the Find layout but I can't work out how to create a selection of unique values in two fields (exhibionID and artworkID). Find Duplicate values in ExhibitionID returns all exhibitions with only one artwork.
Your help is much appreciated!