Contacts by Customer

larshs

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

foo_bar

take a look at the contact business relation table

larshs

Thank you so much - enjoy your weekend

BR.
Lars

foo_bar

take a look at the contact business relation table

larshs

Thank you so much - enjoy your weekend

BR.
Lars

DigitP

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.

sorenhinrup

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.