Setting up Relationships and/or Subforms

[Little Lady 64]

I have an Access database with two tables. One table is Students, the other
is Requirements.

I have a field call Status in the Students table. I want to add data to the
Requirements table for those students marked Current in the the Status field
of the Student table.

My primary key in the Students table is Social Security Number.

As Current students are added to the Student table, I need to add data to
the Requirements table.

I need to set up a relationship or subforms or something to make this work.

Please help.

 

[John Vinson]

On Wed, 20 Jul 2005 11:00:09 -0700, "Little Lady 64" <Little Lady

I have an Access database with two tables. One table is Students, the other
is Requirements.

I have a field call Status in the Students table. I want to add data to the
Requirements table for those students marked Current in the the Status field
of the Student table.

My primary key in the Students table is Social Security Number.

As Current students are added to the Student table, I need to add data to
the Requirements table.

I need to set up a relationship or subforms or something to make this work.

Please help.

What is the structure of your Requirements table? Do you actually have
a many to many relationship from a list of Requirements to a list of
Students? If so you may need a third table.

Adding "placeholder" records to the Requirements table is almost
certainly NOT necessary, nor the best way to do what you want!

John W. Vinson[MVP]

 

[Little Lady 64]

I tried unsuccessfully to set up relationships, so currently there are none.
What is the best way to do what I want? I'm open for any and all
suggestions. I need this database ready to go in a couple weeks and I have
over 200 records to update before then.

 

[John Vinson]

I tried unsuccessfully to set up relationships, so currently there are none.
What is the best way to do what I want? I'm open for any and all
suggestions. I need this database ready to go in a couple weeks and I have
over 200 records to update before then.

You'll have to explain what you want. You know the answer to that; I
don't, and my telepathy is on the blink.

What is a "requirement", in a real-life sense? Can you give me an
example? Might a single student have several requirements which they
must meet? Might a given requirement pertain to many students? Does a
student have one and only one value of Status, or might they be
Current with respect to one requirement, and not current with respect
to a different one?


John W. Vinson[MVP]

 

[Little Lady 64]

I tried unsuccessfully to set up relationships, so currently there are
none.

You'll have to explain what you want. You know the answer to that; I
don't, and my telepathy is on the blink.

Sorry, you're right, I didn't explain very well. I'll give you some
background and a better explanation of what I need from the database. This
is a database I've used for years but recently I was given the task to notify
instructors whether or not their students have provided required
documentation to train in local medical facilities.

These Requirements include having a current physical, health history, CPR
certification, TB test, MMR, HIPPA training, etc.

My database looks like this: one table with many students. I have a field
called Status (graduate, current, prospective, dropped, failed, etc.) Each
student marked Current (in the Status field) must show proof of having met
Requirements.

What I want to do is query for Current students, then fill in a form (or
whatever) for each student that lists all the requirements (some requirements
will have a check box, some will have a date) they meet.

Then, I want to print a report that lists Current students that do not meet
all of the requirements and specifically WHICH requirements are not met for
that student.

I think I've explained better, if not let me know. If it's better/quicker
to discuss this over the phone, I can arrange to be here in the evening and
the school can pick up the tab for the call. Thanks for your help.