In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

The supervisor table would use that as a foreign key in each field and combined make a unique primary key.<BR><BR>Once you get that working I'd just use the record in the supervisor table in the ...