Beginner Crystal Reports question

[Netnoobie]

Hello all!

I have a report that contains a location number. This number is linked to another table that has the text value for each location. So my question is, how in the selection formula for this field, can I refer to another table in like a SQL Where check?

I know that probably doesnt amke much sense. Im going into table1 for all the data in the report. But in table1 the location returns 11 and I need it so say Ohio for example. But that text is in table2 (where the 11 is the ID). How can I get to Ohio in table2 using the 11 I got from table1? Ive tried a few things but my mind seems to want to write SQL type code there and it doesnt work. The tables are linked in the report, but on the ID not on the Location Text. Is this a problem?

Please let me know if I can explain more clearly or anything. Thanks!

 

[Daspoo]

Netnoobie:
This probably isnt the answer you want to here, but heres a suggestion to approach the issue. Perhaps itd be better if you based the report on a stored proc. where you extract the location name from table2 after gathering whatever data you need from table1. It sounds kind of odd that you would have two tables, both with essentially the same information ("Location"), but in different presented forms (one as an ID# and the other as the text equivalent of that ID#). Just a thought.