Is there any was to run a query that does update the primary key?
C Crazy Registered User. Local time Today, 17:04 Joined Aug 2, 2001 Messages 14 Aug 4, 2001 #1 Is there any was to run a query that does update the primary key?
V v.khawaja New member Local time Today, 17:04 Joined Aug 2, 2001 Messages 9 Aug 4, 2001 #2 Eh? Yes an update query will do this – more details required.
C Crazy Registered User. Local time Today, 17:04 Joined Aug 2, 2001 Messages 14 Aug 4, 2001 #3 i get a message saying "validation rule" and i looked in the help and its says because the primary key field already has data in it, it cant be updated? thanx for ur help by the way
i get a message saying "validation rule" and i looked in the help and its says because the primary key field already has data in it, it cant be updated? thanx for ur help by the way
P Pat Hartman Super Moderator Staff member Local time Today, 12:04 Joined Feb 19, 2002 Messages 43,400 Aug 5, 2001 #4 This might be easier if you post the SQL.
V v.khawaja New member Local time Today, 17:04 Joined Aug 2, 2001 Messages 9 Aug 20, 2001 #5 Yes - it could be that the value already exists or that it cant be changed cos it is part of a relationship. Can put show the sql?
Yes - it could be that the value already exists or that it cant be changed cos it is part of a relationship. Can put show the sql?