frame relationships.

[patweb]

I have a problem in defining the relationship between few tables.

1. tblcontact has one relationship to one frame [ICG][BEL]
2. Each frame is composed out one or more subframes.

Mike has access to frame [ICG][BEL] (two frames, for other contacts more or less).
frame [ICG] contains a certain number of pages.
[ICG] page1
[ICG] page2
frame [BEL] contains certain number of pages (1 to X)
[BEL] page3
[BEL] page6

tblcontact - tblframes - tblsubframepages ?
"MIKE" - [ICG][BEL]? [ICG] page1
[ICG] page2
[BEL] page3
[BEL] page6

many tks, pat.

 

[dhookom]

This doesn't make much sense to me. You first say tblcontact has one relationship to one frame. Then you suggest that Mike has access to two frames. I don't understand how this is possible. You need to provide a better description of your tables and data.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[patweb]

Sorry for the confusion.

A contact has access to one headframe. But one headframe is composed out of one, two or more subframes. For each subframe I can say which pages are member of the subframes. I need to make it manageable. There are eight subframes. And the headframes are every possible combination between the subframes. So one contact has only access to on headframe.

 

[willir]

Three issues...

First, what is a "frame" ? So I can put this into context.
Second, are the rights inherited? If Bob can access ICG.page1 also means he can access ICG.page2??
Three, are the sub-frames a "child" of the "head frame"?

You will have to decide if you will relate the Contact to the HeadFrame, or each of the sub-frames.

You will have to decide if you have a one-tmany, or a many-to-many relationship.

Richard

 

[patweb]

I decided that one CONTACT is related to only one HEADFRAME.
One HEADFRAME can be assigned to several CONTACTS.

Each HEADFRAME is composed out one or more SUBFRAMES and every page in this subframe is accessible by the CONTACT who has access to the HEADFRAME with these SUBFRAMES. Every existing SUBFRAME can be assigned to several HEADFRAMES.
SUBFRAMES can be seen as childs of the HEADFRAMES.

A frame is in .html and the goal is to group pages.