Hi,
   I am using crystal reports 10 and have set up a formula as follows -

if ({QuikCharge Auth.cardno}) = ({Calling Card Table.cardno}) then "(Calling Card Table.firstname)";

   QuickCharge Auth and Calling Card are 2 different tables however in the case where entry cardno from the QuickCharge Auth table is the same as the cardno in the Calling Card table the report should output the corresponding "firstname" entry from the cardno table.
   At the moment the only return I get is a column full of "Calling Card Table.firstname" as opposed to the data corresponding to the actual data from the table.

Ok,
I will try that can you define join since the table are already linked through a few fields. Is there a graphic explanation of where I need to go. If you look at the formula

if ({QuikCharge Auth.cardno}) = ({Calling Card Table.cardno}) then "(Calling Card Table.firstname)";

The data in the Quickcharge Auth table cardno is the same as cardno in the Calling Card Table however in the particular column this formula is in all I need is the data pertaining to Card Owner's name etc..

There is some level of success since it has already recognized the rows where the 2 values are the same however the formula as indicated above is inserting the string (Calling Card Table.firstname) in the column where the condition is true instead of returning the data in the firstname field from the Calling Card Table