No announcement yet.

Update issue with primary key

  • Filter
  • Time
  • Show
Clear All
new posts

  • Update issue with primary key

    I am sure someone has had this happen to them..
    I have a table that I created a form against.
    The table had 3 primary keys against it previously.
    I decided to go another way and make each an autoincrement and use that field as the primary key.

    When I go and try and update the record it still uses code based on the previous primary keys.

    I verified that this was true by creating another form and updating it and I see the autoincrement id is being used to update correctly.

    I have removed all the primary key checkmarks off the form, regenerated, still cant get the form to update using the new primary key.

    I really dont want to have to recreate everything i did.
    is there a trick to getting the app synched up right?