Value List Problem with FM 11 Adv

[john9210]

FM 11 Adv, Windows 7 (64bit)

I’m going around in circles with this one. I’m trying to insert a match field into a record by selecting a name from a value list. The value list is based on two fields: field 1 which is the match field (fkRecordID) and field 2 which is a person’s name. The value list is set to show all values from field 2.

However, there is one name on the list, say Sam, that I cannot select. When I try to select Sam, FM inserts another name from the list, apparently at random. I can select any other name with no trouble and FM inserts the correct match field. I’ve tried deleting and re-creating the Sam record but get the same result. I’ve tried changing relationships without success.

Has anyone else experienced this type of problem?

[comment]

It would be best to post a file showing the problem - preferably one simplified to show only the problem.

[Vaughan]

Both the IDs and the second field values must be unique: my bet is that there is more than one person called Sam.

If this is likely to happen, make the second field unique by concatenating the primary key e.g., "Sam 12" and "Sam 23".

[adyf]

Both the IDs and the second field values must be unique: my bet is that there is more than one person called Sam.

If this is likely to happen, make the second field unique by concatenating the primary key e.g., "Sam 12" and "Sam 23".

Hi Vaughan, just for the benefit of my understanding would the name field need to be unique too? Wouldn't the fact that the IDs are unique be suffice?

[bcooney]

No, both fields need to be unique when you are showing just the second field.

[Vaughan]

"Both the IDs and the second field values must be unique..."

[bcooney]

@V - your accent through him off, lol.

[Vaughan]

Like the joke about the difference between a buffalo and a bison... you wash your hands in a bison. LOL