I am having a major problem with a report.
I have a list of customer and a list of contacts.
I want a report of all customers.
When Customer name field is blank I want to use the contact name field of the first contact. A customer can have more than one contact, and sometimes does not have a contact at all.
The customer and contact tables are linked with a 3rd table called xref. This table holds a list of contact customers.
Please can anyone help, I am going bold here....
Andy......
I have a list of customer and a list of contacts.
I want a report of all customers.
When Customer name field is blank I want to use the contact name field of the first contact. A customer can have more than one contact, and sometimes does not have a contact at all.
The customer and contact tables are linked with a 3rd table called xref. This table holds a list of contact customers.
Please can anyone help, I am going bold here....
Andy......