table w/ multi relationships frozen to view 1 relationship only?

[Guest]

I construucted a table that has many relationships from several junction
tables. After creating the first relationship, a view of the table showed the
relationship field with a column of plus signs in the left-most column
correctly. After clicking the + sign the underlying data displayed correctly.
We created the second relationship. Initially when we tried to view the
Table a database window displaying all the tables came up and we selected the
second junction table we had created the relationship for. When we closed the
table and re-opened it for view, again the selection window came up allowing
us to switch the relationship view.
Access allowed us to do this switch several times but then the selection
window did not appear on opening the table and our relationship view is
frozen to just one of the relationships.
Has anyone else experienced this problem and knows of a resolution?

 

[Guest]

If you have a table which has many sub-tables and you choose a "foreign"
table to, I don't think it is possible to change it (tho I could be mistaken).

 

[Dirk Goldgar]

In

I construucted a table that has many relationships from several
junction tables. After creating the first relationship, a view of the
table showed the relationship field with a column of plus signs in
the left-most column correctly. After clicking the + sign the
underlying data displayed correctly. We created the second
relationship. Initially when we tried to view the Table a database
window displaying all the tables came up and we selected the second
junction table we had created the relationship for. When we closed
the table and re-opened it for view, again the selection window came
up allowing us to switch the relationship view.
Access allowed us to do this switch several times but then the
selection window did not appear on opening the table and our
relationship view is frozen to just one of the relationships.
Has anyone else experienced this problem and knows of a resolution?

You probably didn't save the change to the table design the first few
times you did it, so the tables Subdatasheet Name property remained set
to "[Auto]". Once you specify a table to display in the subdatasheet
and save the table design, that property is rewritten.

You can change the Subdatasheet Name property on the table's property
sheet in design view. You can set it to the name of a specific table
(in which case you may or may not also have to fill in the Link Child
Fields and Link Master Fields properties), or you can set it to "[Auto]"
to force Access to prompt you the next time you attempt to open a
subdatasheet, or you can set it to "[None]" to prevent any datasheet
from appearing.