Linking by Formula

[elf1]

A table I have includes two possible fields that have the Account Number (key). If the line type is "1" then the Account Number comes from field1 if the line type is "2" then the Account Number comes from field2. I've created a simple "if then else" formula to determine the account number based on line type, but the problem comes when I try to link that to the Account detail table. In visual linker I have both field1 and field2 pointing (tried =, left outer join, right outer join) to the Account key in the account master table because I need the Account description in that field. If I just link from one of the two fields that contain the account number I can get the description, but as soon as I link both I get nothing.

Any help would be greatly appreciated, if you have additional questions or need clarificaton please reply.

Thanks,
Bryce

 

[MisterMo]

You need to get the account description table twice and still use left outer join for both tables

simply link one of the table to field1 and the other to field2

Mo

 

[elf1]

I have done what you suggested and setup Account and Account_1 tables and the fields in my other table linking each to one. On the report I print both fields on top of eachother because one should be blank. However I'm unable to see any data because when I refresh the report crystal hangs and never returns any data. Any help would be greatly appreciated.

Thanks,
Bryce

 

[MisterMo]

Have you tried to run the query from SQL?

What version of CR are you using ? Database?

Mo