I need help with this. I can't seem to figure out a simple way to accomplish what I want. I am using Crystal Reports XI. I have a table on a database that contains the value of a zipcode. The field is memo so it does not show up on the database expert as a field that you can link to another table. I have a zipcode table on a different database that has a field for the zip and the state that matches that zip code. Ideally I would like to link the zipcode field from the zipcode table to the value field in the other table. Looks like this:
|---------------------| |---------------------------|
|Profile_values | | zipcode_Number |
|---------------------| |---------------------------|
| fid | | zipcode |
| uid | | State |
----------------------- ---------------------------
Value is a data field from Profile_Values but it does not show up on the database expert when I link the tables. If it did I could link value to zipcode. Can anyone offer me a way around so that I can get the state (zipcode_number.zipcode) that matches the value of zip in the Profiles_values.value field? Any help is deeply appreciated. Thanks.
IP Logged
