Value list displaying PK instead of 2nd field value???
I want the popup to insert datafield into field1.fk in the layout.
It worked a few hours ago. Then I changed something (grrrrrr) and can't understand what I did to make it only return the table2::field2.pk
Here is the setup:"
there is a one to many relationship between Table1 >--------- Table2
In table1 I have a ValueList popup as follows:
field1.fk get's it's values from table2::field2.pk and table2::datafield
Also Display from 2nd Field is checked.
Show only from 2nd field is checked.
When I select a datafield in the popup it inserts the table2::field2.pk instead of the table2::datafield.
What is the most likely mistake I MADE in creating this 'anomolie'???