Different Relational Table types: Profiling and Lookup

Profiling table:
Is a table that directly extends the Contacts table and that has a « foreign key » defined and linked to the Contacts table.
This table has a direct connexion with the Contacts table which allows to quickly use its data in groups, searches, etc... 

Lookup table:
Is a table that has no "foreign key" integrated in it's design but can still be used as a reference table in Queries.


Please sign in to leave a comment.