AnsweredAssumed Answered

Value list displaying PK instead of 2nd field value???

Question asked by synergy46 on Jun 28, 2009
Latest reply on Jul 1, 2009 by synergy46

Title

Value list displaying PK instead of 2nd field value???

Post

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:"

 

2 tables:

 

   table1:

      field1.fk

 

   table2:

      field2.pk

      datafield

 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'???

 

 

 

Outcomes