John W. Colby
jcolby at colbyconsulting.com
Wed Dec 31 15:00:07 CST 2003
Uhh... Well..... If the PK is a real data field or combination of fields, then change any of those fields. If the PK is an autonumber or the like, you don't. In fact changing PK values isn't something you normally do. Are you asking how you change the value in a FK in another table? John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Melissa Sener Sent: Wednesday, December 31, 2003 11:15 AM To: Access Developers discussion and problem solving Subject: [AccessD] SQL Server 2000 - Need to change a value in a primarykey... Does anybody know how to change a value in a primary key in SQL Server 2000? Melissa _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com