foreign table

A table that contains a foreign key field that's the primary key field in another table in the database. A foreign table is usually on the "many" side of a one-to-many relationship. An example of a foreign table is a table of customer orders related to a table of customer names by a CustomerID foreign key field.