Access 2007 Reports

[Phreake]

Hi All,

I am creating a report for a form in my database. This form/table has
data from other tables using combo-boxes, so the users can see the
full name but the actual table only stores the ID (primary key of the
record).

What I need help with is when I create a Form from this table it only
shows the ID and not the full name.

How can I get the Form to show the full name of th record.

Thanks in advance

Phreake

 

[KARL DEWEY]

In your query join the ID to the table that has ID and name.

 

[Phreake]

In your query join the ID to the table that has ID and name.
--
KARL DEWEY
Build a little - Test a little










- Show quoted text -

what type of join do i need to use?

 

[KARL DEWEY]

Inner join as you will not be displaying name without a detail record.

 

[Phreake]

Inner join as you will not be displaying name without a detail record.
--
KARL DEWEY
Build a little - Test a little






- Show quoted text -

Thank you