It sounds like you set everything up correctly by linking the two vendor tables to the list of requisitions. I assume it's returning the correct data?

You are correct that you need a formula to display the correct vendor. field. In the Field Explorer, right-click on the Formulas node and select New. Then enter a formula name.

In the formula Workshop you'll need to enter a formula which tests the req type for a value and returns one of the two vendor fields. Here is some dummy code which you'll have to clean up with your own field names (it's easiest to double-click on the field name in the Fomula Workshop window at the top rather than typing them in and possibly making a typo).

 if {table.reqtype} = "a" then
    {VendorTable1.VendorName}
else
    {VendorTable2.VendorName}

Play around with this and see how it goes. If you're new to Crystal, you might want to consider getting my Encyclopedia book. It teaches you everything there is to know about Crystal Reports and I have tutorials through the whole book that let you practice what you learn. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

Edited by BrianBischof - 27 Mar 2008 at 1:10pm

Okay, I did some checks on the data, and using the req_type is not going to work after all.  Apparently the vendor#, in some cases, can exist in both tables.  Grrr.....

Edited by kneedeepinit - 28 Mar 2008 at 7:14am