>I have a form that has been giving me some grief for over a week now, and I am at my wits end on this one. It is also my first time accessing one table under several aliases.
>The form/table relates a record that has a site and a provider. Both the site and the provider are links to a table normally called constit. I have two aliases of constit, one called prov_con, and another site_con. Each field points to the appropriate alias of constit. As I step through the main table in the form, it will lose the relationship with the two alias tables. I have the form in a private datasession. When the relationship breaks, all the fields tied to the constit aliases go blank, and all hell breaks loose. I have the relationships set up in the DE for the form.
>
>Anyone have a better way for me to do this, or know why the relationships are breaking up? Maybe its because of the high divorce rate? :)
>
>PS: Thanks for the help with the outer join!


Is this one physical table only? Why are you linking the same table to each other? Settng a realtionship to itself may be the problem.. I have never done that before. What is it you are trying to accomplish?

Tom