Report shows ID instead of name

[KerryL]

I have a simple DB with two tables:
tblContact (names, addresses, etc)
tblOrgs, (name of orgs contacts belong to)

Each contact has a primary org and a secondary org. The tables are linked so that when a contact is entered into tblContact, a pri & sec org is assigned via the key field (OrgID) in tblOrgs.

The problem I'm having is that when I create a report that lists all contacts, the primary & secondary organization fields contain the OrgID (from tblOrgs) instead of the actual organization name.

How can I get the report to display the org name instead of the OrgID number, even though the field itself contains the OrgID number?

Or is there a better way to link the org names to the contact records than putting the OrgID number in the corresponding tblContact field?

If I haven't explained this very well, please let me know. If you can help, thank you very much.

KerryL

 

[KenReay]

Hi

"How can I get the report to display the org name instead of the OrgID number, even though the field itself contains the OrgID number? "

base the report on a query joining the Contacts and Orgs Tables (on OrgId), in the report use teh Org name not the OrgId

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[KerryL]

Yes, that's what I'm trying to do but so far I'm not having any luck getting the org names to come up in the query or the report. Just the OrgIDs.

 

[hneal98]

can you show the SQL part of your query here?

 

[KerryL]

I got it to work. I guess I didn't understand what Ken meant, but when I added the org table to the query for a second time I was able to pull the primary and seconday orgs for each contact listed.

I also had to place a default value in each contact record secondary field, otherwise the query only produced results for the contacts with two orgs.

Anyway, thank you!