Junction Table Needed??

[pas123]

I’m having trouble defining Relationships I’m thinking I need a “Junction” Table and I have tried looking at the Orders.mdb but it hasn’t helped (I’m sure I’m just missing something) I just don’t see how it works. If at all possible please don’t just give the info try to help me understand so I can get the answer myself.
Here is what I have:
Far table:
FarNumID (PK) > autonumber
FarNumber > Text “224-10C”
FarTitle > Text

FarParagraph table:
FarParaID (PK) > autonumber
FarNumID > Number
FarParaTitle > Text
FarParaText > Text

AC table:
ACNumID (PK) > autonumber
ACNumber > Text
ACTitle > Text

ACParagraph table:
ACParaID (PK) > autonumber
ACNumID > Number
ACParaTitle > Text
ACParaText > Text

1. Each FarNumber can have only 1 FarTitle 1:1
Each FarNumber can have many FarParaTitles 1:Many
Each FarNumber can have many FarParaText 1:Many
2. Each FarTitle can have many FarParaTitle 1:Many
Each FarTitle can have many FarParaText 1:Many
3. Each FarParaTitle and have only 1 FarparaText 1:1

Thanks so much.

 

[pas123]

Perhaps I should just include the FarNumber and FarParaTitle in the ACParagraph table. And include the ACNumber and ACParaTitle in the FarParagraph table....

 

[pas123]

Wait, as I've seen in other posts that would not be the thing to do.

 

[wazz]

what are a FAR and an AC?

you are trying to create relationships between table-attributes (fields) instead of the tables themselves. try rewording your relationships in terms of the tables:

- Each Far can have many FarParagraphs 1:Many
- Each AC can have many ACParagraphs 1:Many

make sure your fields are in the correct table. use the correct language to check accuracy:
Not:
- Each Far can have only 1 FarTitle 1:1
But:
- Each Far consists of 1 FarNumber, 1 FarTitle, 1 this, 1 that, etc.
(what you have is not so bad ("can have only") , but there is no relationship, per se; the relationships are between tables.)

i'm seeing a lot of similar field names and wonder if there might be some way of putting things together and adding a field "Type" (FAR or AC). i'm not sure what those are though, so...?

i know i haven't touched on junction tables but start with that and see if you might make some changes and repost with any questions. hth.

 

[pas123]

Thanks,
FARs and ACs are like books... Chapter "125", Title "Aircraft standards", paragraph "a", and Text "actual text for paragraph".

I think you may have set the path for me. I think I got cought in the fields and forgot the tables.... I'll let you know.