Relationships with Forms

[TylerTand]

I have a form (New Subject) that is the result of a query of three tables(Subjects, Encounters, Intelligence). The relationships of each are One to One. I also want to have a form(Subject View Only) that has two sub forms in it. A Main Subject Form and a sub Form for Encounters, and a sub Form for Intelligence. In this form, each subject can have multiple encounters, and multiple pieces of intelligence. So this Form draws from the same three tables but has a different set of relationships. This form will show the Subjects biographical information from the Subject table,as well as all of his encounters, in datasheet view, in the Encounter Sub Form. Also a Sub Form with all of the intelligence information about the Subject. I am doing this in Access 2003.

I know that I can adjust the relationships between tables in a form when they are the result of a query of the three, but what if they have Sub Forms embedded in them. I am afraid that I will mess up the relationships of the New Subject Form when I create the Subject View Only Form. I know how to edit the relationships by going to the relationships page. If I have all of the forms closed and I go to the relationships page, which relationships do these go to? I can't find a place where it says that these relationships apply to Form X and a different arrangement of relationships for Form Y. I am sure this is a clear as mub but I did my best to explain it. Your help is greatly appreciated.

 

[Guus2005]

The relationships you mention are only related to the tables. Not to the forms. The forms only show you what you want them to show. If you want to show a different relation than is set in the relationship window, it is possible. Just bound your form to a different query. The relationships which are set in the relationship window are usefull when using cascading deletes and updates or in the query design window or when you want to delete a record when related records are present. You get an error message. But when you want to change the relationships you have already set, then it's a different ballgame.
Sometimes it is not possible at all to change them. Most of the time you can only change them when the tables are emty.

BTW, Your Subject table relation to the others can't be one to one. Must be one to many.

Enjoy!