Won't let me create relationship (1 Viewer)

[kickballMVP2006]

Structure of db

tables
divs(divid, div, div_short, div_num)
subdivs ( subdivid, divid, subdiv)
issues (issueID, issue, issueName, subdivid)
subIssue1 (subissueID, subissue, issueid)
subIssue2 (subissue2id, subissue2, issueid)
resolution (resID, labeltext, subIssueID)
resolutionlink( resID, labeltext, linktext, navURL, suIssueID)

relationships
div and subdiv (1 to many)
subdiv and issues (1 to many)
issues and subIssue1 (1 to many)
subIssue1 and subIssue2 (1 to many)

Now resolution table could have a one to many relationship with either issue table, subIssue1 table, or subIssue2 table. When I go to create any of those relationships, Access won't allow me. Tells me it can't create this relationship and enforce referential integrity.

Possibly I need to restructure my database to accomodate?
I am not sure, any help would be appreciated.

 

[ejstefl]

Without commenting on the structure of your tables, when Access will not let you enforce relational integrity it is generally because one of the tables has information the other does not.

In this case, it is telling you that you have records in resolution (the many side) without a related record in subissue (the one side).

 

[RV]

Possibly I need to restructure my database to accomodate?

What you need to do is to add foreign key colums to your "many" tables.
Otherwise you can't build any relationships at all.

I suggest you do a bit of reading on how relational databases work.
Also, do read up on normalization as I don't think your current table structure is appropiate.

RV

 

[FatD]

hey i guess this site might help you.... http://msaccess.batcave.net