NEWBIE here. asp page has 5 forms going into 5 tables with 1 submit. Needed because not all 5 tables will be displayed all the time as the info may be added to the table from a flat file.

Use a command rather than an INSERT.
You can specify what goes where much more effectively

Sharing knowledge saves valuable time!

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]

I will try that. May be difficult with my knowledge of commands. Thanks TS

The wizard is pretty similar to the INSERT wizard, you just need to say what type of command it is (INSERT) and then what you want to insert and where to put it.
Check out this quick tutorial www.drdev.net/article01.htm

HTH

Sharing knowledge saves valuable time!

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]