Skip to Content
0
Former Member
Sep 15, 2007 at 07:40 AM

Crystal 9 Std. - Linking tables - Different data types

23 Views

Post Author: ADEHR

CA Forum: Data Connectivity and SQL

Lets say that you have 2 tables called 'TableA' and 'TableB'.

Now lets say that you wish to create a link between the two columns in the tables:

TableA.ItemID <--> TableB.ItemID

But lets say that TableA.ItemID is of type integer and TableB.ItemID is of type string. Is there a way to create the link without having to touch the backend database?

If it is not possible in Crystal 9, is it possible in any newer versions?

Any input would be appreciated. Thank you.