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
The greatest waste of time is poor design.
Bill Winter "First Hand Experience" 2003