Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BASIC PROBLEM'S ANSWER ELUDES ME! JOIN AND IDENTITY

Status
Not open for further replies.

specialist

Programmer
Sep 7, 2001
50
US
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
 


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?

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top