lance has three tables in his database. He wants to generate a report to show data from the three tables. Therefore, he decides to link the tables. What type of fields will help lance to create his relationships?
Two of the three tables in his database should have foreign keys that link to primary keys in one of the other tables. That way he can join the tables together.