AnsweredAssumed Answered

Value List not working...

Question asked by synergy46 on May 21, 2009
Latest reply on May 23, 2009 by KIDO

Title

Value List not working...

Post

I have 2 tables:

 

Table 1 Customers

   CustomerID.pk

   CustomerName

 

Table 2 Transactions

    CustomerID.fk

    TransactionID.pk

    TransactionDate

    TransactionAmount... etc

 

Customers is 1 to many with Transactions with "Allow record creation..." checked for Transactions.

 

The layout is based on Customers

The Portal is based on Transactions.

 

   On the Portal, I have put Transactions::CustomerID.fk as a popup with Display Values From Fields... Customers::CustomerID.pk and  Customers::CustomerName

 

   Above the portal, for my own information, I have placed Customer::CustomerID.pk

 

   THE PROBLEM:

        As I select Transactions::CustomerID.fk popup values, the Customer::CustomerID.pk record pointer DOES NOT CHANGE.  (I can see this in the field above the portal)  This results in weird behavior in the portal field Transactions::CustomerID.fk.   For example, when I click out of the portal, whatever portal rows that are NOT equivalent to Customers::CustomerID.pk  are DELETED????

 

I am stumped.... Got any ideas?

 

Thanks for reading.

Outcomes