Contacts by Customer

larshslarshs Posts: 11Member
Hi,

I'm trying to list contacts by customers (or the other way around), but the only association I can find between the two is the customer contact no. But based on that I can't seem to look up the customer to get the customer no. It's for exporting data, and I need to combine customers and contacts by the customer number.

Any pointers will be greatly appreciated - thanks:)

BR.
Lars

Best Answers

  • larshslarshs Posts: 11
    Accepted Answer
    Thank you so much - enjoy your weekend :)

    BR.
    Lars

Answers

  • larshslarshs Posts: 11Member
    Accepted Answer
    Thank you so much - enjoy your weekend :)

    BR.
    Lars
  • DigitPDigitP Posts: 38Member
    How does it work if you import the contacts ? because the relation is not made yet ? im building an customer importer and need to import the contacts as well.
  • sorenhinrupsorenhinrup Posts: 85Member
    DigitP wrote: »
    How does it work if you import the contacts ? because the relation is not made yet ? im building an customer importer and need to import the contacts as well.

    You would need to develop some logic for connecting the imported contacts to a customer. On the Contact table there is a trigger called CreateCustomerLink you could look at.
Sign In or Register to comment.