Text Box (stand alone) and Combo Box data (Table)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form based on my Contact Registration Table. On the Form
there is a Combo (yes/no) box (for each class name) to indicate if the
contact attended the class. There are 22 classes in all.

I added a text box on the Form (not linked to any table/query) that has a
control source that if the above check is YES then the contacts name
populates in the text box field.

Bottom line is I'm trying to come up with an Registration/Attendance report
using the Contacts Name for the Instructors use before class and a check list
for after. The Yes/No feature of the combo box isn't giving me what I need.

I now want to report on the text box information, is this possible?
 
Pam,

I'm not sure I totally follow you, but there is a many-to-many relationship
between Contacts and Classes, which is a cue that you need an intermediate
table to represent it as two one-to-many relationships.

ContactClasses
--------------------
ContactClassID AutoNumber (Primary Key)
ContactID Integer (Foreign Key to Contacts)
ClassID Integer (Foreign Key to Classes)
Completed Yes/No

Then you can implement a main form based on Contacts and a continuous
subform based on ContactClasses, linked by the ContactID. You needn't show
the ContactClassID; Access will assign it behind the scenes.

To initially load records for each class for each student into
ContactClasses, do an append query:

INSERT INTO ContactClasses ( ContactID, CourseID )
SELECT Contacts.ContactID, Courses.CourseID
FROM Contacts, Courses;

Hope that helps.
Sprinks
 
Back
Top