I am trying to build a view in SQL 2005 to SuperOffice 6.3 that shows the firstname, lastname and private address (not the company address - the person address) of all of the 'persons' in superoffice.
I need to see the person in the view (first name and last name) even if they do not have a private address.
SDK is telling me:
"A person’s private address will have Address type Person 16384 + Subtype private 3 = 16387 as atype_idx in the address table"
I can get the persons with 'Company Address' but not private address.
Any help much appreciated.