I am very new to VBA. I need to be able to write a function that relates two tables based on a UI. The relationship between the two tables is a many to many relationship, so I have a 3rd table with no duplicates of the UI. I then want be able to identify a record in Table 2 by apply the following criteria: table1![depth1]>= table2![depth1] AND table1![depth2]<= table2![depth2]. Then I want to update the table1![Name] with table2![Name]. When...