syntax?

[sueviolet]

Would it be possible for you to show me the exact sql commands to use ?

Thanks - I am not having any luck with the command snytax you gave me

 

[sueviolet]

Sorry, i posted new post instead of reply to post, Here is my original question:


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.