ValueListItems calculation not working.

[North2Alaska]

I have two related tables, PO_Job and Job. I want to produce, in a portal, a list of all jobs that do not have a relationship to PO_Job.

So, I created a value list, Assigned Jobs, of all the Job keys from PO_Job.

In another table, Preferences, I have a global field, AssignedJobKeys, that is a calculation: ValueListItems ( Get ( FileName ) ; "Assigned Jobs" ).

From Preferences I create a relationship to Jobs: AssignedJobKeys (not equal) JobKey. I then have a layout based on Preferences with a portal displaying the jobs.

After creating the calculation, the field is filled in correctly, but as I create entries in the PO_Job table, the calculation in Preferences does not update. As a result the portal displays the wrong data.

Any idea of what I am missing?