I have a "Client" table with a standard serial number primary key, and a text field that contains the client name. I have a value list that has the primary key as the first value, client name as the second value and "Show only values from second field" selected.

On a few different layouts I have popup menus using this value list.

I am encountering a really strange problem, whereby if the client name includes a number, the popup menu will show the client name value of the record whose primary key is that number.

For example, if I have a record of a client called "Company 7", and another record of a company called "XYZ" whose primary key is 7, and on one layout "Company 7" is selected from the popup menu, the same field will sometimes show "XYZ" on another layout.

I have been through this over and over looking for problems and can't find anything obvious. The fields are set as the correct type, number and text. I thought that perhaps it was because the value list was being created from a different table instance so I duplicated it for each instance that uses it, but to no avail.

Might anyone be able to shed some light on this?

Never mind, this was a truly stupid mistake - I had the wrong field selected as the data source in one layout, it was set to the client name field rather than the primary key field