Search results

Thanks a million 👍

Hi Majp...if it's possible I just wanted to find out what you done to make the chapter selection on my "books" form function and filter it only to display the selected book and chapter in my "verses" form.

Thank you, I will delete then rebuild the form

I've attached the correct version, are you able to assist me with this code please

Hi please find attched correct version.

Hi I've created a cross-reference (see also or related to) pop up form, which will allow users to display any verses that are linked to a specific verse as cross-references. For example, if Verse A mentions or has a thematic link to verse B, this relationship can be displayed and accessed...

Thank you for the nice touch on the chapters selection combobox, ive found the inconsistencies in my data and yes it was in chapter_id and null values in verse_id...🤝

Thank you after running queries and analyzing my data i have found the inconsistencies 🤝

WOW!!! Okay I'm convinced that you have solved the problem, can you please in Leimans terms tell me how do I get my database to good functionality concerning this specific issue at hand. you have provided me with much insight above as to altering my table with explanations so much that it...

I think you made sense when you said there are missing associations in my Data, so in my SQL workbench I ran the below queries on my data just to see what I could establish, please see my SQL comments & code in screenshots below. when i ran your inner join in mySQL worbench i recieved the same...

Thing with the chapter table is that it holds: chapter_id PK auto incr Book_id chapter_number Now the chapter_id counts entry from 1 down to the last thousands and the chapter_number will restart at soon as a new book_id starts

but something doesn't make sense to me if I am drawing data from the same My SQL Workbench be, and I've sought my data from the same dataset using the same tables how come does the first four columns data only pull through with this query in access?

Thing with the chapter table is that it holds: chapter_id PK auto incr Book_id chapter_number Now the chapter_id counts entry from 1 down to the last thousands and the chapter_number will restart at soon as a new book_id starts the only solution I can think of is to add the "book_name" column...

Wow 👍Let me do a quick analysis of my data

so my million dollar question would be how do I fix this error in my data?

yes sure

yes I noticed that your query only returns books if it has associated chapters and verse, which would assume that all my other books hasn't any associated chapters and verses...is this correct and if so, could my problem be with my relationships?

in my books form when I select the first four books in my combobox, Genesis, Exodus, Leviticus, Numbers and click my "Open Verse Form" button it opens my Verse Form displaying the respective data related to the Book Name I selected in my combobox (thanks to the incredible help i recieved from...

Thank you, I will look into this

Hi bob just wanted to show you a diagram of my relationship structure as I cannot understand how is it that you don't see any defined relationships nor primary keys, I really value your insight, Thank You