I need to enter a single row into tr_citystate. How do I get the next id number for this table?
Dale
I don't think you need to. The ID in that table is an identity column, so it's created automatically when you do an insert. Just skip that column when you insert a new row.