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

Union Query to pull contacts together but only for individual cust - Damian

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.

Union Query to pull contacts together but only for individual customer - John Vinson

On 22 Nov 2006 21:09:23 -0800, "Michael" <michael.nilsen@sgs.com>


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]