Including data from another table in a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry to be the one to ask the dumb question - but I can't see how to solve
my problem.

I have a table for Expenses incurred per property.

I input the data via a form and use a drop down menu populated by another
table (Address' Table) to populate the address column.

When I look at the table, the address column is filled with the Unique ID
from the Address' Table. Ideally I would prefer it was filled with the actual
address from the dropdown menu, but assuming I could make a report where
rather than the Unique ID being shown, the Address was somehow translated
from the Unique ID, I would be happy...

So how do I do that?

Thanks in advance for your help.
Russell.
 
Russell said:
Sorry to be the one to ask the dumb question - but I can't see how to solve
my problem.

I have a table for Expenses incurred per property.

I input the data via a form and use a drop down menu populated by another
table (Address' Table) to populate the address column.

When I look at the table, the address column is filled with the Unique ID
from the Address' Table. Ideally I would prefer it was filled with the actual
address from the dropdown menu, but assuming I could make a report where
rather than the Unique ID being shown, the Address was somehow translated
from the Unique ID, I would be happy...
Click to expand...

You do NOT want the full address in two tables. Instead,
create a query that joins the two tables on the addressID
field.

A good rule to follow before creating a report is to first
create a query with all the needed data and no unneeded
data.
 
Back
Top