Moving data from one table to another

[Warren_J]

I have a database (I have enclosed a simple version) that has 4 tables. Names, Active, Disenrolled, Completed. The names table is used to lookup and associate the person with the classes they are taking. Active is classes they are currently in... you can figure out the rest.

What I am trying to do is create 3 buttons.

One button moves the selected item from the Active table to the Completed table. However, in the completed table there are different fields than the Active table... so somehow I want to make it possible for the user to input those items.

One button does the same as the first, only it moves it to the Disenrolled box.

The last button I want to use to add items to the Active Table... each item entered by the user.

Thank you in advance for your help!

 

[ghudson]

I am using Access 97 so I am not able to look at your db. It sounds like your tables are not properly normalized. You should not be "moving" records from one table to another. You should have a field in the main table that designates whether the person is "active" [Yes/No] and/or "completed" [Yes/No]. Set the form up to allow the user to complete different data fields if the person is active or inactive.

HTH

 

[Warren_J]

Access 97

I have attached the file in what it tells me is compatable with older versions of access. I noticed a lot of people in these forums use 97, is there a specific reason for that?

Here's how my tables work... I'm sure there is a better way, but I'm not sure how to get from where I am to that better way.

I have a Names tables with names and SSN's, I then have 3 more tables all associated to the names table by SSN so when I pull reports I can do it by name. The tables are Active, Completed, and Disenrolled.

When a person signs up for a class, I add the class to the Active table manually. When they have finished it and the class website shows their test score, I have to manually delete it from the Active table, then put it in the Completed table with their grade and the date it was graded. However, if they drop the class I delete it from the Active table and add it to the Disenrolled table, and put in the disenrolled date and grade (if they failed they can be disenrolled and have their failing score shown there)

So it's not really as simple as an active or not (Yes/No) field.
Or if it is then I am just not following... Thank You for your help!

 

[Warren_J]

and here is the file

oops... here it is