Re: Relationship Question
- From: Technolust <queensknight@xxxxxxxxxxxxxxxx>
- Date: Wed, 31 Oct 2007 16:53:50 -0000
On Oct 31, 8:59 am, "Keith Wilby" <h...@xxxxxxxxx> wrote:
I have three tables with 1:M and M:M relationships:
tblSubSystem
ID (PK)
SubSysName (Text)
tblJoin
SSID
OPID
tblOperation
ID
OpName
A Sub-System can have many Operations and an Operation can be performed on
many Sub-Systems. This works OK. However, I have another table for
Actions:
tblAction
ID (PK)
ActionName (Text)
Each System/Operation combination can have many Actions. How do I achieve
this relationship? I have a hunch that I need to join to both fields in
tblJoin but I can't visualise it. Can anyone help?
Many thanks.
Keith.
If each Sys/Op combination can have many Actions, then just add an
ActionID to tblJoin. And add that new column to your primary key.
Each Sys/Op/Action combination will be unique.
.
- References:
- Relationship Question
- From: Keith Wilby
- Relationship Question
- Prev by Date: Reoccurring log D/W/M
- Next by Date: Re: Relationship Question
- Previous by thread: Relationship Question
- Next by thread: Re: Relationship Question
- Index(es):
Relevant Pages
|
