Advice about linking tables and storing data

[checkOut]

Hi all,
I likely get some advice about linking tables,
it handles between 4 tables:
tblHome: HomeID (PK), ......
tblJoin: JoinID (PK), HomeRef (FK), .....
tblAction: ActionID (PK), A_HomeJoinRef, A_RefID, ....
tblNotion: NotionID (PK), A_HomeJoinRef, A_RefID, ....

The idea behind this way of storing data is:
The action or notion can be handled to a Home or a Join,
(when it's for a Home it's logical for all Joins in the Home, but not reversable when it's for a Join, it's for the Join only) The RefId is necc. for storing 1 = Home, 2 = Join. This is necc while Home and Join can have a same numbered ID

Now I force relations between Home and Join (1-many)
But can I also force relations between Home and Action
, Home and Notion, Join and Action, Join and Notion?

Thnx for all the advice in advance,
Gerard

 

[Trendsetter]

Gerard,
Sorry to be blunt but you are not explaining what any of the tables are for. It is impossible to imagine what kind of relationships you will require if we no idea of what you are trying to acheive and why.

Give us a chance!