Hello there -
I have a table of Riders (names, gender, etc). I have a table of results (location,rider last name, rider first name, team, year, penalties, etc). I have a field in my results table called Last Name. The Results:Last Name field has a value list based on the Last Name from the Riders table. I have two riders with the same last name, so I set the value list to display value of the First Name so I can pick the right rider.
When I enter a new result in the Results table, the drop down value list only shows 1 of the riders with the same last name. I'm guessing this is expected as FM will only display unique values. I have a field called RiderID, but then I can only show the last name and then I can't tell the two riders apart.