I want to get the name of the contact in the lookup field
npe01__One2OneContact__c on Account object.
How do I get the contact name using a SOQL query?
There's nothing NPSP-specific about querying from the Household to the Primary Contact as such - it's just a normal SOQL relationship query, using the
syntax, which here would be
The only unique feature of the NPSP that comes into play here is the account model. Because you're working in an org that has Primary Contacts, you should be using NPSP 3.0+ with the Household Account model, which is where that feature is available.