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?