Create a selection table by combing unbound fields and existing ta

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

Guest

What I am trying to do is create a table which will obtain all students of
type x, which I have already in a table, have two other parameters entered in
unbounded text box fields, run a MAKE QUERY which combines all of the fields
into one whole table, which has the addition of a CHECK BOX so the user can
run down the list and indicate who is present. Along the lines of a "Daily
Attendance Tracker," with a twist.

Any ideas?
 
What is your question?
Yes, it's possible but its not a good idea to create a table that contains
information that exists in other tables. You need to start off with a good
normalized table design. Sounds like you need an attendance table, which
would contain something like:
Student id (links to Student table)
Date
Present Yes/No

-Dorian
 
Thought of that. However, in this particular case, we have many options of
types of meetings one can attend (combo box: name = combo1). A meeting can
be at any time/date; thus, I have to allow for the user selecting the date
(unbound text box: name = dateActivity), plus the additional field of a time
credit (unbound text box: TimeCredit). My thinking was after all selection
fields are filled, they click the command button which would fire probably an
Append Query to add this meeting to a table which would hold all prior
meetings.

In other words, an intermediate table could be created which would narrow
the number of students that would come up in the table which would have the
check mark if they attended, and after all have been done, send that table to
an Append of a Master Meeting Table.

If this is indeed creating an unnormalized database, then by all means I am
open to suggestions. However, the underlying problem is getting my fields
joined up with my table.

Thanks for any advise, thoughts of wisdom, direction, or general moral
support you can give.

fs
 
Back
Top