i'm new to sql
i know some basics
i have to insert a value in multiple tables somthing like
Expand|Select|Wrap|Line Numbers
- INSERT INTO table1(col1,col2)
- value(val1,val2)
- INSERT INTO table2(col1,col2)
- value(val1,val2)
the id in table 1 is an autonumber but not in table 2 int table
hopefuly its explaind enough
how do i do this in acces and sql server 2008