Union Query to pull contacts together but only for individual customer

[Michael]

Hi All,

I have combo box in my main form which pulls together all contacts
within my customers table with a union query. What i need to do is only
pull up the contacts replating to that client. I also want to select
this contact as the primary contact who will be on quotations ect ect


Thanks

 

[Guest]

Hi Michael,

Have the query driving your combo box use a where clause to limit the
records to only those contacts related to the client. eg:

Select ContactID, ContactName from tblContact where ContactClientID =
forms!frmClient.lngClientID

Hope that helps.

Damian.

 

[John Vinson]

Hi All,

I have combo box in my main form which pulls together all contacts
within my customers table with a union query. What i need to do is only
pull up the contacts replating to that client. I also want to select
this contact as the primary contact who will be on quotations ect ect


Thanks

We'd be glad to help if you could a) describe your table structure, b)
describe your query (post the SQL), and c) indicate what problem
you're having. Based on the above all I can say is "add criteria to
the appropriate query or queries" but since I don't have any idea how
your tables are structured, I can't suggest how that might be done.

John W. Vinson[MVP]