Quick Base Connected table not updating key field

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
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?
Photo of Matt NZ

Matt NZ

  • 296 Points 250 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Esther

Esther

  • 702 Points 500 badge 2x thumb
You can see if there is any error ;