Relationship issue

[cross5900]

This is either going to fall under the query section or the report section but since this pertains to my report I figured I would start here.

I have my main_tbl that is setup with a relationship on the field AccountType with tbl_AccountType, so it will display the name rather than a number in the main_tbl.

Now in my query I have made for the report it displays how I want it too but in the report it just shows the ID number rather than the title of the AccountType. Which makes sense oddly enough to me... I just can not think of a way to make it come out without the number.

Any ideas, or did I make this confusing?

 

[gemma-the-husky]

in the query, put the table, tblAccountType also. if the relationship is not shown, drag it in the query design panel. Now drop the account type name in from the tbl accounttype, and use THAT column in your report.

look in this database for reasons NOT to include lookups within table design.