Remedy 7 connecting two databases

[Butlertl]

Ticket number are INCIDENT_NUMBER (string 15) in the HelpDesk database and APPLICATIONUSERFRIENDLYID (string 80) in the SLM_Measurement database...I am trying to LINK the two with these fields without success.....could it be the field size not matching?

Thanks

Terry

 

[lbass]

Yes. How do the two fields display? There are a couple of ways you could accomplish the linking.

-LB

 

[Butlertl]

What do you mean? The data in the field?

INC000000000419

 

[lbass]

If the longer field can sometimes hold up to 80 characters, what part of the field would hold the equivalent of the incident number? You would have to use a formula to extract the matching characters.

-LB

 

[Butlertl]

Each field holds the same data.....the larger field will never hold more than 15....one of the programmers was just here and will confirm this....

 

[lbass]

I guess it has to do with using two different datasources. Try adding one into a subreport and then use the linking field as the subreport link.

-LB

 

[Butlertl]

I'll try it.....Thanks