HELP NEEDED - Linking fields in formula

[PhotoMommie]

I have 4 linked entities: 1) Accounts, 2) TaxTable 3) Purchase Order 4) Case

Here is my code:
//Link Builder to Job
accountId = case.accountId;
taxCity = case.siteAddressCity;


//Figure Tax
ifThenElse(
account.taxExempt == true,
applicableTax = 'EXEMPT',
applicableTax = number\round(taxRate1 * subtotal, 2)
);

I need to link taxCity to taxTableName

Maximus Can you help me figure out why the taxTable does not auto-link if I use:

taxTableName = taxCity;

???

[Maximus]

Hi,
The 'taxTableName' is a part of link field (taxTableName, taxTableId). So I think when you are trying to change the taxTableName to taxCity, the taxTableId is not changing, so the system automatically assigns the taxTableName value again. Could you tell me what is the 'taxCity' field type? Is it 'Varchar' type field?

[PhotoMommie]

Maximus No, the taxCity Field is a text field.

UPDATE: OK, I figure that the taxTableName is not relating to the ID of the taxTable. I did a work-around to get it linked:
IfThen(
taxCity == 'GILBERT',
taxTableName = 'GILBERT';
taxTableId = '5ea70c8c8f64b9844'
);

I think there is a smarter way of doing this, but I can't brain right now.