Dlookup 1

[eatwork]

Hi, is there a way to do a dlookup type function within crystal reports? I have a problem because I have a report that is based on two tables. These two tables have no relation what so ever. The first table is my customer table, and the second table is a table filled with constant data that may be changed once in a while.
So my report is based on the customer table. I have a formula field in this report that needs to go to the constant table and return the value column where the constant field equals a certain value.
eg.
=DLookUp("value","tbl_CONSTANT","ConstantType='SOMETHING'")

Thank you

 

[synapsevampire]

Instead of requesting proprietary functions in MS Access equivalents, try posting technical information and requirements.

What we need to know:

Crystal version (any software posting about any product)
Databse/connectivity used
Example data
Expected output

You're not in an Access forum, and most won't know what you're speaking of, and the means for doing the same here is different.

Plus you give no indication of what you intend to do with the returned value???

The equivalent is likely to just join the table on the field using a left outer, since you're looking up a value in a field, and looking it up in a field in another table.

But I'll withhold further guessing until you can post technical informtation instead of stating the architecture you want us to use.

-k

 

[eatwork]

Hi synapseVampire,
Thanks for the reply. I should be more specific. The tech info is:
crystal reports.net? (the one within vs2005)
Access database - unbound, using connection strings etc. with a local dataset that stores all of the data from the db
Table "Constant":
Col: ConstantType Value
Tax .06
thankYou "Thank you for your patronage..."

I would like to return for example the value of thankYou in a report and concatenate the thankyou with some data that is returned in another query. The two tables are not related and that is why I cannot add this table to the current query. Thank you