Can I set-up a lookup field to find a custom filed in another module.
For example in a Quote, I want to lookup a custom field called: "Customer Ref No" instead of the standard subject field?
When setting up the lookup field I only get to select the other module, i.e 'Account' and it selects the standard field only.
If not possible could I setup a look up statement to say if field = Account name then input the the Account Ref Instead?