I have a report that is based on an Access query of a table.  The query
returns several codes (10, 231, 44, etc) that relate to several tables,
(Products, CompanyStatus, Contact, etc).  Is there any way to do a "table
look-up" in crystal against a access table.

Can it be done in a formula field, something else.
i.e. Formula = LookUp("tblContact", ID = 100)

You can't use the stored procedure feature to run against an access module,
can you?

I realize that I could just return the code descriptions in the query
instead of the codes, but I am curious.

Thanks

Subreports do exactly this.

Jim.

I haven't tried to do it but my impression is that when you have a stored
procedure that has to be your only data source.

I would try however to add the lookup table and link it using the Visual
Linking Wizard and see if it lets you do it and if it does does it work.
Let us know what you find out.

To your question you cannot do what you want in a formula but you could do
it with a subreport.