Updating a table with data from another table

[JohnDoe]

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.

[JohnDoe · Accepted solution]

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