AnsweredAssumed Answered

Find records with two unique fields

Question asked by walt105 on Oct 17, 2018
Latest reply on Oct 20, 2018 by philmodjunk

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!

Outcomes