If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two &quot; article number &quot; data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets.
例如，有一个商品表格，其中的商品用商品编号标识；还有一个客户表格，用相应的商品编号记录了客户订购的全部商品。这两个表中的“商品编号”数据字段之间就存在关系。如果现在要建立查询，反馈某位客户订购的所有商品，就需要从这两个表格中检索数据。为此，必须在 $[officename] 中指定这两个表格所含数据之间的关系。