append particular records to particular records in another table

[sueviolet]

Hi there:




I need to append records 11709-13847 from the field "Main_id" to records 1-2139 in another table (Barriers).

I don't want to simply add on the records from "Main_id" to my barriers table.

How can I do this? The reason I want to do this is because the records in the Barriers table link to records in the Main table - they are linked by the "Main_id" field.

Thanks for your help.

Sue

 

[pdx_man]

Assuming that Main_ID is not an AutoNumber field AND there isn't currently a record with Main_IDs 1-2139, try this:

INSERT INTO Barriers( Main_ID , Field2 ... )
SELECT [Main_ID]-11708 AS Expr1, Table1.Field2, ...
FROM Main;

 

[sueviolet]

main id is an autonumber field

Main_id is an autonumber field in the main table and a number field in the barriers field (table i am trying to append to)

There aren't records with Main_IDs 1-2139

Does this make a different to the sugguestions in the above post?


I am using access 97 - I am newbie - where do I type in the commands from the above post.