Update field for all records in table
I am needing to update a field in every row of a table with a value from another field. and there is almost 23k records that need to be updated. [Job Tracker Reverence Number] = FID 157 (Formula...
Forum Discussion
You could use a simple table to table import for your jobs table to itself.
1) import export
2) import from table
3) pick the job table (or whatever its called)
4) pick the same table as the source table
5) map recordID->recordID + job reference number -> job number (you can leave all the other fields blank)
What the above will do will basically push the value of your formula to your numeric field for every record.
Hope that helps!
Charlie
1) import export
2) import from table
3) pick the job table (or whatever its called)
4) pick the same table as the source table
5) map recordID->recordID + job reference number -> job number (you can leave all the other fields blank)
What the above will do will basically push the value of your formula to your numeric field for every record.
Hope that helps!
Charlie