Combo Box with duplicate LastNames - only selects first one

[MediaDoc]

My combo box displays LastName | FirstName | ClientID (invisible).

The result populates the rest of the form with the client information.

When I select "Smith | xxxxx| it always populates with the first record containing Smith (i.e. Smith, Adam), despite me choosing Smith, Rob).

I can successfully select any other LastName, if there are no other people on the list with the same LastName.

Any suggestions appreciated.

Steve

 

[ColinEssex]

It's probably because the linked field is the last name. Make sure the linked field is a unique ID

Col

 

[MediaDoc]

Damn - how did I overlook that! Yes, you were correct. I changed my bound column to the ClientID, and presto it works.

Many thanks.