AnsweredAssumed Answered

How can I join fields in a database?

Question asked by Wallis on Feb 6, 2010
Latest reply on Feb 7, 2010 by jimbrownle


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?