I have two separate DB data sources. One is a Foxpro DB the other is a SQL Server DB. I can add these data sources and add the tables I need to display. The problem is how these tables are linked. The Foxpro DB table has a varchar column for an order number. This is the hard-coded key that I need to use as the lookup. For example say the order number is '001-001234.' The SQL Server DB table has this value stored in a column that has extra data in it. For example it could be 'Customer'sName / 001-001234' or 'Customer'sName/001-001234' and the like.
Can I perform this sort of a link? It's not an absolute match. It's the equivalent of a T-SQL LIKE statement. I could look to use regular expressions, although I don't think this is supported in CR XI R2, correct? I'm at a loss as to the possibility of what I'm looking to do. 😕