Possible linking error has me confused

[aaronburro]

Bear with me, I'm a bit new to Crystal Reports, so I'm trying to figure this little thing out.

I'm trying to display the phone number for the shipping destination on our Bills of Ladings. Currently, the workaround is to place the phone number on AddressLine3 for both ShipTo's and in Customer Maintenance. Ultimately, this is not helpful, because sometimes we need to use AddressLine3.

So, I made a formula that looks like this:

if {SO1_SOEntryHeader.ShipToCode} <> "" then {AR1_CustomerMaster.PhoneNumber} else {SOB_CustShipToAddress.Telephone}

I then proceeded to add the tables AR1_CustomerMaster and SOB_CustShipToAddress.Telephone. Then, I went to the linking expert and linked as follows:

SO1_SOEntryHeader.CustomerNumber --> AR1_CustomerMaster.CustomerNumber
SO1_SOEntryHeader.CustomerNumber --> SOB_CustShipToAddress.CustomerNumber
SO1_SOEntryHeader.ShipToCode --> SOB_CustShipToAddress.ShipToCode

I link all of these using the normal equal-to link

Then, I go and run MAS90 and go to Picking Sheet Printing, choose the form and click Form to edit/preview the form. When I go to the lightning bolt to refresh the data, I get the following message:

"ODBC error:[ProvideX][ODBC Driver]Column Not Found: PhoneNumber"

Then I click OK and it tells me there was an error in the database.

My guess is that I am linking wrong. Any help would be appreciated

 

[synapsevampire]

You might try the MAS90 forum:

forum637

We do occasionally get some MAS 90 experts here, but it varies.

-k

 

[aaronburro]

aight. I'll put it there, too. I'm new to this place, so I apologize for putting the previous thread in the wrong section. got here via google and just figured it had Crystal in it, so it was prolly the right place

 

[synapsevampire]

Nae worries, just trying to help.

We aren't MAS90 join experts for the most part. We do have one in particular, dgillz, but he's apparently otherwise occupied most of the time these days.

-k