Discussions

Expand all | Collapse all

Quick Base Connected table not updating key field

  • 1.  Quick Base Connected table not updating key field

     
    Posted 04-16-2018 00:04
    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?


  • 2.  RE: Quick Base Connected table not updating key field

    Posted 04-16-2018 09:32
    You can see if there is any error ;