I'm having a confusing time with this problem...Hopefully someone can help!!!(and I'm sure someone can...)

I'm trying to organize contacts. There is tblAdmin, tblPTO, tblStaff, tblStudents. Is there a way to have ONE form to fill out and something in there to specify which table the information should go in? Or is there another way I can go about doing this? Please help!

Do all these people share the same characteristics? If so, you should redesign your database, drop all four tables, and create a new one called Contacts. This Contact table then has a ContactTypeID that points to a table called ContactType. The latter table stores the types of contacts you have.

This way, you can have one form that inserts data in one table. To distinguish between the type of contact, you could display a drop-down list with the various contact types. Under the hood, the ID of the ContactType can be saved in the database (in the ContactTypeID column).

Does this make sense?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Some of them have different characteristics...Like the tblStaff would have their office hours. Students would have parent's names. From these tables, they will login too. They will each have a username, but staff will have a different "management" area than the students and PTO...

You could have one table for general contact info (name, email, phone, etc.) and then have corresponding tables for admin, pto, staff, students that maintain further info on the user. Just make sure you have a UserId field in each. This would allow some flexibility to cover instances where a user may be an admin as well as a staff member for example. As far as determining which tables to write data to, you can pass a hidden value from the form to whatever page processes those updates.

Dave