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

Title

How can I join fields in a database?

Post

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? 

 

Walt 

Outcomes