Value List changes Foreign Key ????
I have 2 tables:
This database is designed to allow for MORE THAN ONE PROPERTY to have associated transactions. Everything works well except for....
I have a layout based on transactions. It is a sub-summary report that breaks on Transaction::Item
I put a popup in the header that is: Transactions::PropertyID.FK with a value list of Property::PropertyID.pk & Property::Address.
This works well.
The problem is that when I select an address in the popup, it changes whatever record I happen to be on to the PropertyID of the property selected. In the example beleow, East Elm is property 4. But the Benjamin Moore PAINT record previously was Property 5 but was changed to 4 as soon as I selected the East Elm property. As you might imagine, this screws up the report. And, it happens BEFORE any script is run. ie, it happens immediately AFTER the selection is made.
Got any ideas?