Access 2007 Reports

  • Thread starter Thread starter Phreake
  • Start date Start date
P

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
 
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 -
Click to expand...

what type of join do i need to use?
 
Back
Top