specialist
Programmer
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
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