BASIC PROBLEM'S ANSWER ELUDES ME! JOIN AND IDENTITY

[specialist]

Greetings-

This may be really simple, but the answer skips me at the moment.

I would to add the value of the "ID" column from the main table "tblMain" into another table called "tblRandom". I just cannot seem to get it to work. I am wondering if it has to do with the identity seed in the main table being set to 1.

You see, the "ID" field in the 'tblMain' has to be a unique number... a record id number.

All I want to do is have that number added to the secondary table 'tblRandom'. is that too much to ask?

Please help!

many thanks,

mike

 

[maswien]

Do these two tables have same number of rows?

For example, tblmain has 1000 rows, the ID is from 1 to 1000, and the tblRandom also has 1000 rows and you want add a column ID to tblRandom with the same range of ID?

 

[specialist]

maswein-

thank you for your reply. these tables do not have the same number of rows. tbl main has about 240 rows and tblRandom was recornly created. the idea behind this is to add new functionality to the aplication which is a password retreival function.

The function checks the email ( and the ID field just in case the email appears more than once in the tbl)

Basicly, what I want to happen is this:

I want to add the column from tblMain which is called 'ID' (NOTE: This column is autogenerated with the identity seed set to '1') to the tblRandom in order o display a one-to-one relationship between the two records.

any advice?
thank you agian for any assistance......
-mike