WebJan 7, 2010 · A relationship is a connection between two tables of data, based on one column in each. A workbook can store each piece of data in a single place, but display it in multiple places, by storing data into multiple tables with relationships between them.