i currently have 2 tables.
Table 1
File Number, Section Name, Date
Table 2
File Number, Section Name
I want to add the date from Table 1 into a field (also called Date) in table 2. The tricky part is that each File Number has many Section names and i need the date from Table 1 to find the...