Hi,
your goal is not very clear, but if I understood correctly, you can use a way, which also helpful for “no-code lookup” - in less than a minute.
Link both tables to a new temporary table, copy-paste values field into new link fields in both tables and then add 'link to table2" from temporary as lookup field in table 1 (or vice versa, link to table1 into table 2). Then convert it to a link between tables 1 and 2. Remove temporary table and it’s remaining fields in 2 tables.