Skip to Content
Oct 02, 2012 at 01:12 AM

How to get address #?



I am trying to pull the Address # based on the Person #.

I have contact person record in KNVK table, but it doesn't have the address #.

I want to get the Fax # of this contact person, but this fax data is available in ADRC table, which table requires Address #.

So, i found a connection between Person # and Address # in ADR6 table, but, when i wrote a SQL on ADR6 for pulling the Address # by passing the Person #, am getting a ERROR in Extended Prog. Check/Code Inspector, which is not OK in our company, hence, pls. let me know

How to get Address # being having Person # in hand?

Thank you