Skip to main content
Question

Table to table import - override query

  • April 8, 2019
  • 0 replies
  • 17 views
I am about to use a table to table import to update 22,000 records but want to check my logic first.

Table A contains the following fields:

Equipment Record ID - table key 

Equipment Record ID (NEW) - unique value

I need to update Equipment Record ID with the value in Equipment Record ID (NEW).

I propose using a table to table import from Table A to Table A and merge equipment on Record ID#

This seems to be a quick way of populating data - hopefully without unforeseen consequences?







      This topic has been closed for replies.

      That should work assuming that the Equipment Record ID is not the actual Record ID (which is field ID number 3) in the table. An easy way to test is to copy your app and do the test in the Copy app.
      • AndreaPahor
      • Author
      • Registered
      • April 8, 2019
      Just to clarify, the field I'm importing into is not the QBase generated Record ID # field (field 3).

      I'm importing into a field I created (Equipment Record ID) which is the key field for the table. 
      It will probably work, but to copy an app takes about 3 clicks, so I suggest you test if this is a production app.
      Terms & ConditionsAccessibility statement