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!