Report problem...

[dave@homedeliverygroup]

i have generated a report based of my claim data tabel one of the Fields on
the table is a drop down list based off a table "market_tbl" the fields in
the "market_tbl" are -- count = autonumber(primary key) and Market when i
select this to print on the report just to get the market to print i get the
autonumber only to print I need the market that was selected in the form.
The market_tbl has the following format:
count Market
1 DE
2 VA
3 MA
4 VA
5 ATL

when i view the report only the "1" will show for the DE market and i need
the "DE" to print on the report... can someone lead me to where i get this to
happen... maybe in the proporties area???

thanks

 

[Marshall Barton]

dave@homedeliverygroup

i have generated a report based of my claim data tabel one of the Fields on
the table is a drop down list based off a table "market_tbl" the fields in
the "market_tbl" are -- count = autonumber(primary key) and Market when i
select this to print on the report just to get the market to print i get the
autonumber only to print I need the market that was selected in the form.
The market_tbl has the following format:
count Market
1 DE
2 VA
3 MA
4 VA
5 ATL

when i view the report only the "1" will show for the DE market and i need
the "DE" to print on the report... can someone lead me to where i get this to
happen... maybe in the proporties area???

You need to Join the two tables in the report's record
source query. Then you can include market field in the
query and the report can bind a text box to that field.

All your confusion would have never existed if you had not
use the evil lookup field in your table. All a lookup field
provides is a what you see is NOT what you get feature. I
strongly recommend that you cange the field back to a simple
text box.

For further thoughts re look up fields follow the link in
the second commandment at:
http://www.mvps.org/access/tencommandments.htm