David and Chris, in the Excel attachment
, is a screen shot of what I would offer on how to model the database, to be able to go from scripture to article. Or even from article to scripture. The key is to model two separate branches, of a hierarchical database, and connect them at the bottom of these structures. Keep in mind that I may not have the Scripture (Bible) side and/or the Article side, correct. In order to get this correct, I would need to understand exactly what part of the article (links, words, sentences, paragraphs, etc) is needed to be isolated and connected, to what part (links, words, verses, chapters, books, etc.) of scripture?
In the screen shot, there is what I would call a "Cross-Referencing" table. It contains only the key, and unique fields, from the bottom tables in the two hierarchical branches. Then a one-to-many connection is made from of these tables to the "Cross-Referencing" table. In order to come to this point, here are some of the questions that I asked:
1. Is there a need to connect the identified part of the article, to only one part of scripture? Or to many parts of scripture? I guessed that there would actually be a need to do both. This is why I came up with a "One-to-Many" link from the article branch to the Cross-Referencing table.
2. And, is there a need to connect the identified part of scripture to only one part of the article? Or to many parts of the article? Again, I guessed there is a need to do both. Thus, the "One-to-Many" link from the scripture branch to the Cross-Referencing table.
It is possible that the answer to these questions could be that there is only a need to connect, one part to one part. For example, there could be, only the need to connect one part of the article to only one scripture. If this was the case then the best option would be a "One-to-One" link. I will touch base with you again sometime this week and see what needs to be done to help with this. Thanks, Otis Bass