Hi,
Question for the experts.
I've got a small relation database that i want to update via an asp. I've got to the stage where:
I've written the asp pages and a load of javascript to validate the entries.
I've created the tables that I want in my SQL server database.
I've written some vbscript to add values to a table in the database.
However..
My database is relational and I thought the easiest way to create unique key values would be to have sql server create them for me.
So how do I relate the records to each other using VB Script?
If I add a record to one table how can I add the primary key as a forign key in another table?
I've not created anything using sql server or asp before and I kind of need some direction.

Phil.