I have a ‘Company’ field which is a keyword field with a @DbLookup formula and another field ‘Area Office’ which is also a keyword field with a @DbLookup formula that is based on the Company field. These two fields work fine.
The problem is that I have a field ‘Address’ which needs to contain the ‘Area Office’ address information. The problem is that there could be multiple Area Offices and I need to ensure the right address is displayed rather than all of them which is what is happeneing right now.
The formula for the Address field is below:
@DbLookup( “” ;@Subset(@DbName;1):Db ; “View” ; AreaOffice ; 3)
How can I get just one correct address to be returned? Is there some way I can do a @DbLookup using two keys? This would work as I could use the ‘Company’ and ‘Area Office’ values.
Can anyone give me a hand?
Cheers,
Katherine