AnsweredAssumed Answered

Relationship gone but "old" data still in portal

Question asked by StefanSaeys on Jan 27, 2015
Latest reply on Jan 30, 2015 by StefanSaeys

Title

Relationship gone but "old" data still in portal

Post

 
If I try to export one record, with all the information of the record + portal, the companies::REF content is different from the one in the record.I have an issue with my relationships.
Between two tables, Properties and Companies, I’ve created the relation:
properties::__pkPropertiesID--------x———<companies::REF>
 
For an unknown reason (most probably something I did wrong earlier), the content of these fields doesn't match anymore.
But in my portal on properties linking to companies the “old” values still are in the portal to companies::REF
 
If I duplicate the tables, then it becomes clear that their relation is screwed up.
One positive thing is that the data still is in there.
 
I’ve tried copying the companies::REF to properties::copy_field but it copies other data than visual in the portal.
Hope this makes some sense; in case it doesn’t the example is https://www.dropbox.com/s/qcvn67o6umc11za/properties2.fmp12?dl=0
 
If I try to export one record, with all the information of the record + portal, the companies::REF content is different from the one in the record.

Outcomes