Contact & Customer relationship

chen_wan
chen_wan Member Posts: 34
Dear All,

What is Contact and what is the relationship between contact and customer.

While we are creating a new sales order, once the customer no. is selected, the contact no will automatically filled in by the system. Where the contact no. value come from. How the system able to relate the contact no with the selected customer no. ? I am not able to find any field that store the contact no in the Customer table.

Comments

  • Mark_S
    Mark_S Member Posts: 17
    Table 5054 Contact Business Relation

    but that's from 3.70 =>
    M Stunnenberg
    GAC Business Solutions B.V.
  • pdj
    pdj Member Posts: 643
    Mark S wrote:
    but that's from 3.70 =>

    It was introduced already in 3.00 but who is counting :-)
    Regards
    Peter
  • DenSter
    DenSter Member Posts: 8,307
    It's a field called "Primary Contact No." in the Customer table, and it should be on the General tab of the Customer Card. When you enter the customer on a sales order, it defaults the primary contact from the Primary Contact No. of the customer.
  • Mark_S
    Mark_S Member Posts: 17
    pdj wrote:
    Mark S wrote:
    but that's from 3.70 =>

    It was introduced already in 3.00 but who is counting :-)

    LOL yeah, then i was misinformed by a collegea of mine .. i'll twist his neck! ;)

    but it IS that table that keeps track of the relations between those two.
    M Stunnenberg
    GAC Business Solutions B.V.