Help

Re: Updating a table with data from another table

Solved
Jump to Solution
283 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JohnDoe
5 - Automation Enthusiast
5 - Automation Enthusiast

We have a rather large table that needs to be updated/inserted with a datefield value from another table. This needs to be done only once.

Table 1 is about 30K records.

Table 2 is about 120 records.

Table 1 (that needs to be updated) is linked to Table 2. 

I'm pretty sure there is a rather simple solution to this conundrum but I can't figure it out.

1 Solution

Accepted Solutions
JohnDoe
5 - Automation Enthusiast
5 - Automation Enthusiast

Nevermind. The solution was to link Table 2 to Table 1 and add the datefield as a lookupfield in Table 1.

See Solution in Thread

1 Reply 1
JohnDoe
5 - Automation Enthusiast
5 - Automation Enthusiast

Nevermind. The solution was to link Table 2 to Table 1 and add the datefield as a lookupfield in Table 1.