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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

merhug - 15 Jun 2007 15:41 GMT

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?

Reply to this Message

scubadiver - 15 Jun 2007 15:53 GMT

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).

> I construucted a table that has many relationships from several junction
> tables. After creating the first relationship, a view of the table showed the
[quoted text clipped - 9 lines]
> frozen to just one of the relationships.
> Has anyone else experienced this problem and knows of a resolution?

Reply to this Message

Dirk Goldgar - 15 Jun 2007 17:27 GMT

> I construucted a table that has many relationships from several
> junction tables. After creating the first relationship, a view of the
[quoted text clipped - 10 lines]
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message