Solved

Updating a table with data from another table

+6

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.

Best answer by JohnDoe

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

+6

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

Sign up