I am having problems getting the desired results out of a view.

I am using a contact table that contains, employee, vendors, and customers.

and a message table that contains messages from all contact types.


I am trying to return all the messages for a contact that is also an employee

What I mean is if message is put into the message table from a contact to an employee and that employee returns a message to contact my view should have two records in it for the contact that is an emlpoyee but I am not getting this, it looks like i am only getting on side of the results no mater what I do.

In the contact table I have contact_id and employee_id and in message table I also have contact_id and employee_id I have both tables in the view and have tried differant conections between how should i do this if it can be done.

Thanks Bill
Fox On