Query to Display Linked Records?

[Emmy]

Hi,

How can I write query that displays not only the record, but specific records that are linked to it?

* I have a table named "Person" with two fields, "Name" and "Occupation".

* On the left hand side of the table "Person" I have a little "+" that expands and links to another table "Information" that has fields such as "Phone Number" and "Age".

* When I write a select query to select certain records from "Person", it only displays the "Name" and "Occupation" fields, it doesn't expand to display the "Phone Number" and "Age".

* How could I write a query that selects certain records from "Person", but would also display the data from "Information" that's linked to those records?

Thanks very much in advance.

 

[Jerry Stoner]

Add table Information to your query and drag fields you want displayed into the grid. Be sure your tables are linked (Primary key of Person table with Secondary key of Information table).