Search results

  1. R

    Update table to replace primary key

    Thanks again guys - and Doc Man - you correctly anticipated the gravity of the employee number, and almost exactly described the steps I've already taken to update my database. Having to update a number of forms that displayed SS num, but just cleanup work. In other settings I can see the...
  2. R

    Update table to replace primary key

    Update query worked as advised. Very much appreciated! I see that a meaningless PK has merits. However, I need a little more time to see how this would work for me. Our district is primarily hispanic - and it is not uncommon to find two or more folks with the same name, and in some cases...
  3. R

    Update table to replace primary key

    Your replies and assistance is much appreciated. Just returned to work this AM, so will try to implement suggestions. The comment about the security factor re the social security number is creating the problem. We have been using an 'SS number to sign the up for classes when they call or...
  4. R

    Update table to replace primary key

    My database tracks all of the staff development sessions provided for the past ten years, thus we have thousands of records. Our school district wants all departments to move away from using an employee's Social Security number to a number assigned by the district. Each employee has been...
Back
Top Bottom