Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002

    Exclamation Unanswered: Not able to update the foriegn key.

    I had to add a new field in a table.That field is the primary key of that table and also it is an auto number.The same field is added to several other related tables as a foriegn key.Now since it is an auto number it got values in the main table,but I am not able to figure out how to asssign the values to the same field(foriegn key) in the other tables.I tried writing an update query but it is asking me to enter a value for eaach update it performs.This way it will take a ling time to update each of the 300 odd records.Can any one suggest a nice technique to do this.

  2. #2
    Join Date
    May 2002
    I would try to compact and repair database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts