Posted by Ed Murphy on 03/21/07 23:01

ebade2000@gmail.com wrote:

> I have two tables (T1 and T2). In T1 I have a field FT1 that is a
> primary key in T2 I have a field FT2 that is a foreign key linked to
> FT1. These fields have been populated with data. Lets say that in one
> row of data I have in T1 under FT1 "my cell" as the data entry,
> similarly with T2 under FT2 I have 2 rows of data that also have "my
> cell" as the data entry. What is the best line of action is I wanted
> to change "my cell" to "my data"?

Revise the table structures so that the primary key is something that
never changes (e.g. INT IDENTITY) and "my cell" / "my data" is a non-PK
field in T1.

Side note: Please use real table/column names (e.g. table = Customers,
column = CustomerKey) rather than confusingly similar abbreviations
(table = T1, column = FT1).

• Next in forum: Re: Database table data modifications with PK/FK relationship
• Prev in forum: Re: help with parameter in WHERE
• Thread view: Re: Database table data modifications with PK/FK relationship

[Reply to this message]