FK column

I have table2 with 3000 rows in it. Recently I added a column for it which is a FK for table1.Now that column appears to be NULL in the table2.
How can I syncronize that column with the PK field of table1 so that the relation between the tables make sense.

Thanks!
"He laughs best who laughs last"

I dont understand, what can you use as a relation between the two tables if your FK is NULL?
You would need a relation of some sort (even if its not defined as a key constraint) in order to join the tables in a sensible way, something like....

update
t2
set
t2.MyNewField = t1.SomeOtherField
from
table1 t1
INNER JOIN table2 t2 ON (t1.?? = t2.??)

What I mean is there was no relation between the tables but now I assume that I need a relationship to these 2 tables. So I inserted a PK column of table1 into table2 and made a relationship.
These 2 tables are already in use.
How can I insert this field into table2 so that it has data which relates to the PK of table1

Thanks!
"He laughs best who laughs last"

OK I think I am confusing you,Let me ask u very clear

I have 2 tables table1 and table2 which is in use and has some data in it and has no relationship between them.
Now I need relationship between these 2 tables, how can I do tht without losing any data?


Thanks!
"He laughs best who laughs last"

You'll have to add the column, then update all the records, to fill in the value for the foreign key, using some other criteria to match up the records in the two tables.

--------------------------
Yes, I am a geek. I know. I can't help it.

yeah even I thought the same thing but cud any one give me some update command that match up with this scenario.

Thanks!
"He laughs best who laughs last"

Like merrillaldrich said, "fill in the value for the foreign key, using some other criteria to match up the records in the two tables."

UPDATE FK_Table
SET FK_Column = Main_Table.Key_Column
FROM FK_Table
INNER JOIN Main_Table
ON .........................................

Insert the criteria on the dotted line.

... and your biggest problem is probably that there is no existing connection between the two tables, so you're actually adding new data. It would then depend either on another column in your FK_Table, or on a third table, and the FK value is probably something you make up as you go along.

Adriaan
Do u mean tht there shud be some column in the FK table that match up with a column in Main table,ie; having a column in both tables which are similar.

Thanks!
"He laughs best who laughs last"

Does Table2 have a (set of) field(s) from which you can tell what goes into the new FK column? Like there's already a region code and a type of business, and this tells you the internal department (new FK)?

Or does Table2 have a (set of) field(s) on which you can join another table, where you find a (set of) field(s) that tells you the new FK value?

If there are no criteria like that, then the FK values will have to be done through data entry (users keying in data).

OK I'll give the structure of my tables and let me know how to update the table2 where I have added a FK column.
Lets say I have 2 tables in this way.
Table1
(PK)DocumentHeadersIDint40
FileHeadersIDint41
DocNumchar160
TrBatchPoNochar500
RecordTypechar20
TCodechar60
HeaderAmountmoney80
LineItemCountint40
RefDocNumchar160
HeaderLiquidationAmountmoney80
PayDateBaseLineDatedatetime81
DocDateInvoiceDatedatetime81
PartnerNumchar100
PartnerPayeechar100
PaymentMethodchar20
BankPartnerchar40
PaymentMethodSupplchar20
PaymentBlockchar10
PaymentTermschar40
HeaderTextchar500
Noteschar790
Parkchar10
VendorValdnSkipchar10
DocHeaderAddlDatachar650
WarrNochar140
BankNochar20
ChkNochar80
PayDatedatetime81
PurDocNumchar100

Table2
(PK)DocumentTransactionsIDint40
(FK)DocumentHeadersIDint41
RecordTypechar20
LineItemNumsmallint20
Fundchar100
GLAccountchar100
CostCenterchar100
IntOrderchar120
WBSElementchar240
Amountmoney80
DrCrchar10
Vendorchar100
DueOndatetime81
ItemTextchar500
RefDocEMFundchar100
EMFundLineItemsmallint20
LiquidationAmountmoney80
GAAPCodechar10
ServicePeriodBeginDatedatetime81
ServicePeriodEndDatedatetime81
Assignmentchar180
RefKey1char120
RefKey2char120
RefKey3char200
TypeCodechar20
DocDetailAddlDatachar380
SetToCompletechar10


Thanks!
"He laughs best who laughs last"

Hemant
what do u mean by "update appropriate records (with integration)"

Thanks!
"He laughs best who laughs last"

I can't see any combination of fields in Table2 that look like they correspond to Table1, except RecordType. It looks like you should have had DocumentHeadersID as the FK in Table2 from the start, now there is no way of telling which rows in Table2 are related to which rows in Table1.

Yeah u r right, but the RecordType has diffrent data corresponding to the table.
So how can I come out of this issue.

Adriann, u know something..I have set up such relations as per requiements for a database which has 25 tables.It seems like I am in a gr8 problem.

Thanks!
"He laughs best who laughs last"

Once you start entering data in two tables without a proper foreign key relationship, and no field(s) where the relationship is expressed in some other way, then there is no way of knowing which rows are related between the two tables.

The entity of Table1 is a document, and that of Table2 is a transaction involving a document. You have 3000 transactions involving unnamed documents. - The transactions should never have been recorded without naming the document.

Hemant
I didnt get you , can u make me clear how i can do tht?

Adriaan
If iam deleting all the records and inserting again, can I get the issue solved. How can I do INSERT after deleting all rows with these joins.

Thanks!
"He laughs best who laughs last"