Check boxes.

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

Guest

I have inserted a series of check boxes on my form. However, they do not
reset themselves when I go to the next record. If I check box #1 on record
#1, it remains checked on record #2. Setting up a technical drawing review
database. Check boxes denote those who have reviewed the drawing.
 
Are they bound to a field in your table? If not, then you will see the
reflex you describe. If you don't bind it to a filed in the table, then it
will simply retain whatever value you put in it on the form. IF you want an
item "checked" for record 101, and unchecked for record 102, then you have
to store the value in the table.
 
I need some more help on this one. Let's say for record 101 employees 1, 2
and 3 have reviewed the drawing. I'd like to click the check box next to
their name. for record 102, let's say no employees have reviewed the
drawing. Where and how would I store this information in the table?
 
I'd have to understand the structure of your tables first.

I would think you'd not use checkboxes if you are marking employees who have
reviewed something. In my opinion this is probably a many-to-many
relationship.

TblDrawing
DrawingNumber
DrawingDescription
DrawingCreationDate
DrawingArtist
etc.

TblEmployees
EmplNumber
EmplFirstName
EmplLastName
EmplTitle
etc.

TblDrawingReviews
DrawingNumber
EmployeeNumber
ReviewDate

Each drawing would have one record in the drawing table.
Each person would have one (and only one) record in the Employees table.

If a drawing was reviewed by six people, you would have One record in the
Drawing Table and six records in the Reviews table.

No checkboxes involved.
 
Back
Top