either make a calculated field, sumofallnumbers, = number1 & " " & number2 & " " & number3
or make a calculated field, sumofallnumbers, = list (number1; number2; number3)
greetings from gemany
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.
The best way to handle this is to have two separate tables for Members and Cars, related by MemberID.
I agree with the calculation to create names that won't be duplicates, but Filemaker also has a fast way to search for duplicates:
To find duplicates, you enter the find model, and enter an exclamation point "!" in the field you want to check for duplicate values. This will return any duplicate values, and you can modifiy the names as needed.
You could use this in conjuction with your field, or just use it to check names on an exception basis.
Another option is to use the data validation to make sure the value is unique. When defining the field, click the <options> button, go to the <navigation> tab, and there is a check box there for "require unique value". That may help you eliminate the duplicates when you are entering the data.
Have fun with the races!