jason73503
New member
- Local time
- Today, 14:12
- Joined
- Jul 26, 2017
- Messages
- 8
Greetings,
I'm trying to develop a database for data-entry of Course Books used by our institutions and related materials and vocabulary for each unit within the Course Books.
I would like your insights of Database Normalization Theory to see if this approach is the most effective as I am experiencing difficulty in entering data into my main data-entry form "frmBookDetails"
The basic premise is to add a single Course Book under a "BookID" and that Book should have many related "Units".
Each "Unit" has many "Vocabulary" and "Materials" associated with them.
Within the "frmBookDetails" I would like to somehow relate the "Units" separately as in the attached img "qryBookUnits" so that I can move from one "Unit" record to the next within the main form.
I'm trying to develop a database for data-entry of Course Books used by our institutions and related materials and vocabulary for each unit within the Course Books.
I would like your insights of Database Normalization Theory to see if this approach is the most effective as I am experiencing difficulty in entering data into my main data-entry form "frmBookDetails"
The basic premise is to add a single Course Book under a "BookID" and that Book should have many related "Units".
Each "Unit" has many "Vocabulary" and "Materials" associated with them.
Within the "frmBookDetails" I would like to somehow relate the "Units" separately as in the attached img "qryBookUnits" so that I can move from one "Unit" record to the next within the main form.