Updates Applied to All Records

[Diyego]

Hey people,

I have a question on a database I'm creating for a human resources office. I'm creating a database that tracks resumes sent and where we sent them. I created a general table that shows the list of places we send the resumes to. As for the resumes I created a form that can add/delete/and update resumes. I linked the table to the form and everytime I update one resume, it updates the table for all the resumes on the list.

In Short, the table is not uniquely manipulated for individual records (the resumes). Can anyone help on how I can manipulate the table for one resume record without manipulating the table for all the records?

Much appreciated,

Gerry

[Krandor]

Your explanation of your problem is somewhat confusing.

This is what I understand. You have a form that directly connects to your resume table. Once you do an update to a particular record (resume), it somehow manages to update all the other resume records?

Without using VBA code or maybe a macro, I don't see how what you describe is even possible. If you can add some more detail as to what is actually happening, it will be much easier to help you.

[NeoPa]

This will work much better if you can post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used. PK & FK stand for Primary Key & Foreign Key respectively. Never use TABs in this as the layout gets mucked up. Use spaces and all is fine.
Table Name=[tblStudent]

Field           Type      IndexInfo
StudentID       AutoNumber    PK
Family          String        FK
Name            String
University      String        FK
Mark            Numeric
LastAttendance  Date/Time

[Diyego]

Your explanation of your problem is somewhat confusing.

This is what I understand. You have a form that directly connects to your resume table. Once you do an update to a particular record (resume), it somehow manages to update all the other resume records?

Without using VBA code or maybe a macro, I don't see how what you describe is even possible. If you can add some more detail as to what is actually happening, it will be much easier to help you.

I have a form that I use to input/update basic information from resumes such as first/last name, street address/ education level/ and job desired (objective). What I did was create a button on the form that brings up the client list (A table of 50 places where we service to find these people jobs). What the HR office wants to do is track where we sent the resumes to and when we sent it.

The problem is if I bring up the client list for resume "John Doe" and input the information of where we sent the person's resume to, then input information into the client list for resume "Jane Doe," then the client list reflects the information of resume "Jane Doe" on resume "John Doe." Basically the client list reflects all information for all resumes. What I was hoping to do was have a unique client list for each resume that way we can track each individual.

If this is still confusing let me know. I'll try to explain it another way.