Determining the Lowest Value between Fields from 2 Separate Tables 1

[dstalls]

I would like to select the lowest value from related fields in two different tables.

I can get the lowest value from each field by using Minimum, but how can I get Crystal to evaluate both fields and determine which is lowest?

Any input? Thanks-

Derik

 

[lbass]

Try:

minimum([{table1.field1},{table2.field1}])

-LB