Skip navigation
charkoul
Currently Being Moderated

Insert recordset in 2 tables with the same id

Jun 14, 2013 5:04 AM

Tags: #dreamweaver #mysql #cs6 #recordset

Hello,

I have two tables with the columns

CAR                              Client

clientId[FK]                  clientId [PK]

carId[PK]                        name

brand                           surname

type 

 

 

I made a form with textfields

Brand

Surname

Name

Type 

 

and I want thru Insert Recordset wizard to pass the cliendId in both tables.

 

How can I do this?

 
Replies
  • Currently Being Moderated
    Jun 14, 2013 10:01 AM   in reply to charkoul

    You can do this by not relying on the recordset wizard and simply coding it yourself to INSERT data to tables. Or use wizard to insert into one table and modify code to allow insert into two tables.

     

    best,

    Shocker

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points