Page 1 of 1

Database design help

Posted: Mon Oct 26, 2020 2:22 pm
by 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

Re: Database design help

Posted: Mon Oct 26, 2020 3:15 pm
by 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.

Re: Database design help

Posted: Mon Oct 26, 2020 3:44 pm
by vanman
Hi Kevin

Thanks
Will look into this seems less complex

I forgot about Hash Cookies


Paul

Re: Database design help

Posted: Thu Oct 29, 2020 12:58 am
by 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

Re: Database design help

Posted: Thu Oct 29, 2020 10:33 am
by vanman
Thanks Heaps Steven

Most Helpful