How can I join fields in a database?
I'm setting up a database in Filemaker 10 for our Vintage Car Racing Club.
We have to make sure that cars of the same age group don't have the same race number - it drives the timekeepers crazy.
Now many guys have more than 1 car, so the database has Car 1 Type, Car 1 Number, Car 2 Type, Car 2 Number, Car 3 Type, Car 3 number. This means that I have to manually search through all 3 Car number fields to make sure that a number isn't duplicated.
Is there some way of combining the Car Number Fields into a single field so that its easy to work out if we have any duplications?