Good luck with the rest of your project.
You should find working with your db much easier from now on
fields like Class_Hours, Oil_Hours, Heavy_Hours should be changed to an HourValue & HourType field.
Replace the 3 textboxes with a 3 column listbox StudentID, CourseName, CourseHours with StudentID as the bound column.
Set the width of the first column to 0 so its hidden
I've tried this, ( at least I think so... maybe went overboard a tad ?)
Once again, I've attached pictures. It seems as though it does show CDL hours and Oil hours, but it shows the same hours for every student and the only way I can edit these numbers is directly in the table it's self. Obviously, I'm doing something wrong, but I think I'm going down the right path ??
I have not removed the "offending", or otherwise, "unnormalized" fields from the students table in hopes of salvaging this data once everything is properly normalized.
You are selecting the whole table so it is just showing the first record.
You need to filter the row source for the listbox for the student id used in the current record of the form.
For clarity, suggest you rename your SystemId field as StudentID and rename the two ID fields prefixing with the table names
At our school, we all ready have an established FAME ID and Student ID, which is why I came up with the term System_ID. For clarity, I changed the name ID in the students table to System_ID , which I do believe makes things easier to understand.
My query SQL that I'm using is:
SELECT Student_Hours.System_ID, Student_Hours.CourseName, Student_Hours.CourseHours, Students.System_ID
FROM Students INNER JOIN Student_Hours ON Students.[System_ID] = Student_Hours.System_ID;
When I add the list box, I choose the query, Course_Hours and follow the prompts for the columns as you suggested, but when I'm finished the textbox still says it's unbound.
OK if you're happy with the naming that's fine by me
The row source gives you the list - does it now filter correctly with the added code?
Its an unbound listbox because the control source isn't set to anything
If you want to bind it, you would set the control source to a suitable field
But in this case I thought you wanted an unbound control.
Sorry - I don't follow what you're saying
Are the screenshots identical?
I'll try & explain again ...
Apologies if you already know what follows
Textboxes, listboxes & combos can be unbound or bound to a field.
Listboxes & combos have control sources which determine what is shown
I rarely use the wizard but if you do so, you can choose to bind the control to a field (option 2) or as you've done choose option 1 to keep the selected output for later use elsewhere in your form (or code)
As I believe you just want to display the list but not do anything with it, you've chosen the correct option & if you want, you can also set the listbox locked so no selection can be made.
HTH rather than confuse you further
but that hasn't changed my results in a favorable way.SELECT Course_Hours.CourseName, Course_Hours.CourseHours FROM Course_Hours WHERE (([Main_ID]=[System_ID])) GROUP BY Course_Hours.System_ID, Course_Hours.CourseName, Course_Hours.CourseHours;
SELECT Student_Hours.System_ID, Student_Hours.CourseName, Student_Hours.CourseHours
FROM Student_Hours
WHERE Student_Hours.System_ID = Forms![COLOR="Red"]YourFormName.StudentID[/COLOR]