Comadeuro

Ok, I'll have to understand the difference. Right. But human beings are not very good in remembering pure numbers. Reading names as text would be much easier for the users. Yes it does. It has given me the significant hint: when sorting the value list by the second field all and multiple entries show up. Sorting by the first field shows only distinct values. That's what I want. Is this strange behavior (result sets depend on sorting) intended? Thank you for your help, Comadeuro

Ok, here is a simple example, which demonstrates my problem. Go to the layout "Ergebnis" and click into a "Nr." field. You'll see a valuelist with all drivers whichever are recorded in "teilnehmer" under this number. Try number "19", which has different drivers. FormulaOne.fp7.zip

It's sorted by driver_name. Yes, I only see one car_no but all records of that car_no with multiple entries of the same driver_name. I want to choose one of the previous drivers, so every driver_name should occur only once. Any idea? Comadeuro

Hi, I have a table "tour" with a "car_no", a "driver", a "co_driver" and some more fields. Because "driver" and "co_driver" mostly use the same car I want to ease the entry of a new "tour" by building a value list of previous drivers of that car. I defined a self-relation of "tour" with "car_no" as connector and a value list of driver_no and driver_name with only related values. Everything works fine, but the list of a car grows with every new tour of that car. How can I suppress duplicate entries, though the list shows only different previous drivers of a car. How can I filter the list values to use only tours of a given time period? Maybe this are simple questions. Please be patient, I'm new to FileMaker and couldn't find a clean and elegant answer up to now. Thanks, Comadeuro