Database design help

[vanman]

Sorry if this seems simple, but I'm bouncing before I get into deep.

I am building a database through nuBuilder that will enable me to make notes, identify keyword on my research on the Bible. I am thinking the following.

There are three levels Book > Chapter > Verse. I want to be able to make notes on each level. I also want to access by Chapter or verse.

Thinking Home would be have a button for each level

Book would enable me to go to Book > Chapter > Verse.
Chapter would enable me to go to Chapter > Verse.
Verse would enable me to go to Verse.

Would I build a form for each level and use lookups to get the level of detail?

The data in stored in a table
bible_id
bib_bible_books_id
b_name
b_index
b_book
b_chapter
b_verse
b_nasb
b_nkjv
b_esv
b_isv
b_amp
b_niv

Also have a keyword table and notes table.


Thanks Heaps
Paul

[kev1n]

Hi Paul,

How about using three lookup objects (Book > Chapter > Verse)

You can use nuSetProperty() to set a hash cookie that filters the SQL.

[vanman]

Hi Kevin

Thanks
Will look into this seems less complex

I forgot about Hash Cookies


Paul

[admin]

Paul,

Here's a database you can muck around with...

vanman.zip

Here's the database structure...

bible.PNG

Here is a Report to explain how you can use it...

report.png

Steven

[vanman]

Thanks Heaps Steven

Most Helpful