If ( IsEmpty ( LastName ) ; SchoolName ; LastName & ", " & FirstName )
Thanks I knew it was something simple.
My next question is do you have any idea why the drop down list is only showing one name out of the 50 or more on that table?
Perhaps you have a field of type number instead of type text. That changes how FileMaker generates indexes from the field and this can result in a single value showing in your value list.
UGH YES!! That was it. I hate that I don't know all these simple little fixes yet.