Calculations in match relationships

[Jim Lah]

I am having difficulty reconciling the results of the attached file.

My ultimate purpose is to simply keep two tables in synch for a data separation model. The attached file is an extract to show the problem I am having.

I am using a calculation c_current ID's to generate a list of the current ID's in the target table. I've added a "null" value in the first record so that it still works when no data is present. That works fine.

I use that calculation with a not equal to relationship to show those records in the source table which are missing. But I get very variable results.

Adding a new record to the target table and filling in an ID results in the c_current ID's being updated correctly, but the portals showing the missing records don't update. They do update when a new record is added to the target.

Scrolling back through the records also shows a strange effect. Even though the c_current ID's calculation always shows the same result, the resulting records in the portals are different.

Opening and closing the edit layout resets everything to be as expected, but adding a few more records to the Target causes the same problem to occur.

What am I missing? Is it a refresh or commit problem somehow?

POC_Copy_Records.fp7.zip

[MorFologist]

Hi,

I found your file interesting. Did you every resolve your needs? I wondered why you used the "flag=1" relationship for a constant over just a [X] relation. I am playing with allowing my UI (target) to create the data record (source) via relationship; typing in a data field to create the record (your sample required typing an id as a lookup).

I had been looking at verifying that my UI record ID lists matched the data, and found your "list missing" method useful. Thanks! For curiosity, I applied my setup to your file and it seems to have resolved your issue.