Really Stumped - Pulling values from related DB

[Blake Lucas]

Not sure where to start. Ok. I have a DB that I have successfully made a field that has a Value List of company names from a related DB. Once you choose a company name, subsequent field auto populate with Address, City, State, etc. based on the company name value.

Do to an oversight when I originally created the DB, I am forced to be more specific on my look ups.

So now, I have made a new field that pulls company name and an Oracle Acct Number from that other DB. Once you choose which company you want, this field populates with the 2nd field value from the value list (oracle Acct Number).

Now.. The auto calculations I have on the company name is:

If ( Bill To Oracle = Contract Details::cont.oracle.account.num ; Customer Details_Workshop::cust.info.co_name ; "Invalid" )

So like the original set up, this calculation says, if that oracle number you just pulled up = one in the other DB, give me the company name, else "Invalid".

I used this same type of calculation before on the addy, city, state, etc, to populate based on the company name instead of the oracle number.

Now all I get is the invalid on the Company name...I am not sure why its not giving me the company name.

All relationships are there... I have the Bill to Oracle field related to the cont.oracle.account.name field and the such...

If anyone could actually decifer my babble and has an idea, please, please, let me know your thoughts.

Thanks,

Blake

UPDATE!!! - I figured it out... was all relation setup... Thanks everyone... no further help needed :

Edited July 13, 2010 by Guest