Checking for Duplicate Records

[DataPro]

When defining a field, you can choose to make it unique, but I have two fields which, by themselves can be duplicates, but combined should be unique. For instance, I have an airport ID number and FBO name (the company that provides fuel, etc.). There can be multiple FBOs for an airport, but only one with the same name. Is there an easy way to stop duplicate records from being created at the time the record is being entered?

Also, I need to create a script to show me the existing duplicates.

TIA

[DataPro]

When defining a field, you can choose to make it unique, but I have two fields which, by themselves can be duplicates, but combined should be unique. For instance, I have an airport ID number and FBO name (the company that provides fuel, etc.). There can be multiple FBOs for an airport, but only one with the same name. Is there an easy way to stop duplicate records from being created at the time the record is being entered?

Also, I need to create a script to show me the existing duplicates.

TIA

[Oldfogey]

Set up a field Combo = auto-enter Airport-ID & FBO-Name. Validate this field for no duplicates - i.e. 'unique'.

[Oldfogey]

Set up a field Combo = auto-enter Airport-ID & FBO-Name. Validate this field for no duplicates - i.e. 'unique'.

[Vaughan]

There is an article on this in the TechInfo database. Search for "validate unique calculation" or something similar.

http://www.filemaker.com/

[Vaughan]

There is an article on this in the TechInfo database. Search for "validate unique calculation" or something similar.

http://www.filemaker.com/