I'm working on a database to store and audit profiles. From the text I import I want a layout with just profile name once where auditors can click on the profile and view new profiles. i thought about using buttons to reference searches however new profiles may show up at anytime. Is there a function similar to excel unique record in which I could script to show unique profile names each time I import new data?I appreciate the help.

I'm also a bit of a newbie - but:

The best way I know of showing unique or duplicate records is with a selp-join. There are lots of articles here on 'finding duplicates' or the FM website or the FMP7 help.

If this is not what you want prehaps you are asking how you mark records as 'new profiles' and navigate to them.

This changes depending if it is a shared database, and what are the criteria of 'new' (date form today / marked after import / etc ?). And if you are using lists or portals to view multiple profile names on a layout?