Hello,

I think that might well have worked!

Thanks to both of you for your help.

Jon

Thank you....

Yes, contacts can be identifield on contact_number. This identifier is available in both the contacts and the contact_roles tables.

Jon

Hello,

Thanks for your help. I've just re-read my initial post and I don't think I've explained myself fully... sorry!

Some contacts have a role of just "MAIN".

Some contacts have roles...