Partial Text Linking 1

[MJSQA]

I am trying to link two ODBC tables. In one table I have a field with a three letter field. In the other table I have a field that starts with the three letter code contained in first table but may continue with a comma and other data. I need to Group by the info in the first table and display the data from the second table in it.
I was going to try partial linking but it was greyed out (later found out it is only for DB access). I was going to try using the Database > Show SQL Query option but that was greyed out. Any ideas?

 

[kenhamady]

You can try using a "Greater than or Equal to" join. Then add a record selection formula that only allows the matches you want. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/