SQL- OCPR Default Contact

[a_a]

Hi

With OCPR and Name field in an SQL query, I get all the contact persons with an SQL query.

Is there any way to get just the DEFAULT contact person? I do not see any field which identifies the record as the default.

Thanks,

Ajay Audich

[jitin_chawla · Accepted solution]

Hi,

Check this query :

SELECT * FROM OCPR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T1.[CntctPrsn] = T0.[Name]

May be you find some hint or something to create one for your self.

Kind Regards,

Jitin Chawla

SAP Business One Forum Team

[a_a · Accepted solution]

Hi Jitin,

Thanks - this has solved my problem.

Ajay Audich