Value list populating problem

[Mitch in Halifax]

I have a problem with a drop down value list that is not populating. The member table had 10 new records added The fullname field is a concatination firstname& " " &lastname. On another layout (Trip) I have a have a value list that is picking up the values from the the member table via a relationship between the two tables Trip:member_fullname to Member:member_fullname. What is happening is when I enter the field a drop down list shows only the last 10 records (total 65). If I select a name the error message "value list is defined to contain exisating values only. Enter a correct value". I have checked the value lists, field options, everything. I just can't solve this problem

HELP!!!

[Mitch in Halifax]

: Ridle solved. It came to me this morning that perhaps the error was as a result of two possible problems.1st that the records were entered on a layout that was originally designed to be a view layout for me. This layout had the fullname field displayed which is a calculation field. The data clerk rather than entering the first and last name on the correct member form entered the full name on this form. 2nd In the field definitions, although I had defined the field originally as a text field and then selected the auto entre tab and checked the calculation option. I constructed the concatination which upon closing became a number rather than a text definition.

I deleated the fullname in the entered records and changed the field types to calculation with the result displayed as text. When I returned to the trip layout and clicked into the client drop down all the records were displayed correctly.

I hope this little explanation will help others not make the same mistakes.

Happy Filemaking :yay: