Quick Base Connected table not updating key field
I have a Job/Phase table with the following fields: Record ID#, Job#, Phase#, Job/Phase (=[Job#]&"/"[Phase#]) and a bunch of other fields.
I then have a second Job/PhaseSync table that uses a Quick Base Connection to get the Job/Phase and Record ID# for each Job/Phase.
Job/Phase is the key field in the connected table, so that other bulk imported data can lookup related Job/Phase record ID# based off the imported Job/Phase value.
This was working nicely, until I changed the value for Phase on one of the records in the Job/Phase table. Now the connected table just keeps the old value for the phase.
Any ideas as to how to make the connected table stay fully in sync with the source table?
I then have a second Job/PhaseSync table that uses a Quick Base Connection to get the Job/Phase and Record ID# for each Job/Phase.
Job/Phase is the key field in the connected table, so that other bulk imported data can lookup related Job/Phase record ID# based off the imported Job/Phase value.
This was working nicely, until I changed the value for Phase on one of the records in the Job/Phase table. Now the connected table just keeps the old value for the phase.
Any ideas as to how to make the connected table stay fully in sync with the source table?
