Accessing Data from a Lookup Table

[TastyMouse]

So I have this problem which is really bugging me.

Say I have 2 tables. Table 1 has:
A Name.
A Phonenumber
And an Address.

Table 2 has:
An Order
A Lookup to the Name of Table one.



My query is finding all people who have ordered a specific item, I use this query as a basis for a report, and I want that report to also contain the address an d phone number of ther person.

Any help?

Thanks

[Beetle]

Join both tables in the query and return the additional fields that you need.

[TastyMouse]

Join both tables in the query and return the additional fields that you need.

So would I be able to create a calculated value in the query on table 2 like:
[Table1].[Phonenumber]

?

[Beetle]

It's not a calculated value, you're just returning fields from more than one table. It would look like this;