Value List not working...
I have 2 tables:
Table 1 Customers
Table 2 Transactions
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
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.