Help

[Guest]

I am trying to write query and report. I have been using relationships and
row sources.

Since my relationships are autonumbered. The data refers to my tables fine,
example 1 = Mike or 2= sam.

But when I am trying to do a query, I can't query by the name Mike, I have
to query by 1.

When I do an autowizard on my report, I see nothing but numbers, instead of
the words.

Is there any way to help me through this process. Thanks

 

[John Vinson]

I am trying to write query and report. I have been using relationships and
row sources.

Since my relationships are autonumbered. The data refers to my tables fine,
example 1 = Mike or 2= sam.

But when I am trying to do a query, I can't query by the name Mike, I have
to query by 1.

When I do an autowizard on my report, I see nothing but numbers, instead of
the words.

Is there any way to help me through this process. Thanks

Base your Report on a Query, joining the main table to the lookup
tables.

I suspect you have Lookup Fields in your Table. If so, you're another
victim of a misfeature: the Lookup Field conceals the actual contents
of your table (the numeric ID fields), and tricks you into thinking
you can base a report directly on the table. As you have found, the
lookup feature is very limited and won't do that for you!

John W. Vinson[MVP]

 

[Guest]

thanks John for all the help today. You were a big help