I am surprised that the Value List did not list both records, with the duplicated School Name and the two School IDs.
This is known and expected behavior for a 2 field value list where you either hide the values from the first field or sort on the values from the second field due to the way FileMaker draws these values from the fields's indexes rather than the actual fields.
Think about it. If you saw this data in your list:
2 Jefferson High School
45 Jefferson High School
How does your user know which one to select? Enforcing a unique values validation rule on the Name field is a good way to ensure that you don't get two records with the same name in your schools table. If duplicate names are possible, it's a good idea to include data from more than just the one name field. in this school name example, you could define a calculation field that combines school name and street address in the same field and then you'd use that field as your second field so your users can see enough info to select between schools of the same name.
The other issue sounds a bit like a bug previously reported click the link below and see if you agree. If you think it is different, please post an issue report in the Report an Issue section of this forum.
For More Information see: Pop-up field displays incorrect value
This is one of many acknowledged bugs that can be found in the Known Bug List here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: http://www.4shared.com/file/8orL8apk/FMP_Bugs.html
Yes, this makes so much sense! I'll solve the issue with a concatenation field. And a unique values validation rule is also a great idea!!
And it seems that bug you suggested is alive and well in FMP v11!