>Hello.
>
>I have three tables
>Table1(code c(5)) Holds the last number used, this is not autoincremental
>Table2(code c(5)) because the user can change the last number printed
>Trans1(code1 c(5), code2 c(5), descrip c(30) ...)
>
>How should be the insert code so I can update all three tables at once ?
>
>c.x.
You cannot insert into 3 tables with 1 insert statement. However, you can create triggers to accomplish the same thing.
Wine is sunlight, held together by water - Galileo Galilei
Un jour sans vin est comme un jour sans soleil - Louis Pasteur
Water separates the people of the world; wine unites them - anonymous
Wine is the most civilized thing in the world - Ernest Hemingway
Wine makes daily living easier, less hurried, with fewer tensions and more tolerance - Benjamin Franklin