Single/Unique instance of a record.
I'm using FMP11.
I'm using a FM DB to track boxes of paper documents. A single box may contain different types of documents... creating a situation where multiple records pertain to a single box. I'm not concerned with the document types/descriptions given to each box, I simply need a method of finding a single/unique instance of each box number. I also don't want to remove these records from the database.
Thanks for any assistance that you can provide.
Define a table of Boxes. One record for each Box. Define an auto-entered serial number field to generate a unique box number. Use a relationship to a documents table in order to set up a list of documents contained in a given box.