By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Updates Applied to All Records

P: 2
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
Sep 29 '08 #1
Share this Question
Share on Google+
3 Replies


P: 50
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.
Sep 29 '08 #2

NeoPa
Expert Mod 15k+
P: 31,660
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]
Expand|Select|Wrap|Line Numbers
  1. Field           Type      IndexInfo
  2. StudentID       AutoNumber    PK
  3. Family          String        FK
  4. Name            String
  5. University      String        FK
  6. Mark            Numeric
  7. LastAttendance  Date/Time
Sep 29 '08 #3

P: 2
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.
Sep 30 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.