Linking 2 tables by Formula Fields

[eebabe]

I would like to link two tables. From table1 - a formula field to table2 - string field. Is this even possible? If not what other solution?

Thanks.

 

[lbass]

What version are you using, and what is the formula you want to use for linking?

-LB

 

[eebabe]

Right now 9 but at another computer 10 and another computer 11. The formula field is alredy done. It's a {IIncident.I_EventNumber}[11 to 15].

Thanks.

 

[lbass]

You will have to use either a command that uses a function like mid() that works with your datasource to link the tables in the from clause, e.g.,

from table1 inner join table2 on
mid(table1.`field`,11,5) = table2.`field`

Or you can add one table in a subreport and then link the subreport to the main report by linking the formula to the field in the other table.

-LB

 

[eebabe]

How about if each of the table is from two different databases? ie: DB_N and DB_W. I would like to link the formula field (@PCR_NO) from DB_N to field (Run_No) from DB_W. Is this possible?

Select * from DB_N.table_N
full outer join DB_W.table_W
on DB_N.table_N.@PCR_NO = DB_W.tabel_W.Run_No

 

[lbass]

I think it depends upon whether you can use the same connectivity for both tables. Why not try it?

-LB