C Crazy Registered User. Local time Today, 11:54 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, 11:54 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, 11:54 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
V v.khawaja New member Local time Today, 11:54 Joined Aug 2, 2001 Messages 9 Aug 20, 2001 #4 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?
