Nothing I can type here will make sense

[Sontec]

This seems to me like it should be really simple, but I can't work it out for the life of me. What I need to do is pull a field from 1 table if a job exists in it, otherwise pull the same field from a different table. If that doesnt make much sense, i'll explain a litle further.

Our system handles electrical unit repair information, and if a job has had spare parts fitted to it, I need to pull the field {Spares.CircuitDesc}...if the job was repaired without the use of parts i need to pull {Instruct.CircuitDesc}.

Can anyone help?

 

[dgillz]

Use a null test:

If IsNull({Spares.CircuitDesc}) then {Instruct.CircuitDesc} else {Spares.CircuitDesc}



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Sontec]

I knew it'd be something stupidly simple. Thanks for solving it so quickly!