Linking two tables

[csjoseph]

I have two tables

Table1
EquipNo

Table2
MfgNo

EquipNo is a string representing a tool
MfgNo is a string representing each tool configuration

example:
EquipNo - 1871 can be three colors so we would have MfgNo's 1871-01, 1871-02, 1871-03

I need to tie these tables together but cannot because of the config info "-XX" after the number.

Does anyone have any ideas? Chris
IS Manager

 

[lyanch]

create a SQL expression that removes the "-xx" and then in your selection formula create the link between the SQL expression and the EquipNo.

As an alternate, you could use MfgNo like 'EquipNo*'

Either way you will need to verify that it has been send in the SQL (database->show SQL) or you will get a huge amount of data for Crystal to sort out (bad thing)

Lisa