relate [database structures] An operation that establishes a temporary connection between records in two tables using a key common to both.