Jump to content

Creating Rows In 2 Seperate Tables, Taking The Primary Key Of The Row In One


smerny
 Share

Recommended Posts

hard to explain fully in title... anyway, i want to create 1 row each in 2 tables at the same time (2 queries one after another i guess)... and i want to use the primary key of the row in the first table in row in the second table...so if the primary key in the row in the first table is 15, i want one of the fields in the row in the second table to also be 15i could do a count rows, but it may be messy in the future if rows are deleted...whats the best way to do this?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...