Adding new data to DB when using 2 tables

Question

I am new to mvc and mvc 3 , I have a db that contain a company table (string id =as the company name )

And a table tourism that contain same info I would like to be able to add data to the tourism table , while selecting a company from the list (that came from the company table) (The two tables had a dependency vie company_id (and the same name in both)) How can I do it? Leo_a

user244313 · Accepted Answer · 2011-04-27 13:40:55Z

0

I'm not sure I understand the question. You want to select from one table and update the other with the data you selected from the first? Do you have any sample code you can post?

answered Apr 27, 2011 at 13:40

user244313

Sign up to request clarification or add additional context in comments.

1 Comment

leo Over a year ago

hi, no, i have the comapny lets say USA airline, (this is in company table)and they have a flyet rout to London and paris and Berlin (this is table tourism) i would like to update the scound table using the company's in the first table I hope this is more clear

General Grievance · Accepted Answer · 2025-03-12 13:07:56Z

0

Create a transaction
Insert into the dependent table
Insert into the main table
Commit

edited Mar 12 at 13:07

General Grievance

5,12039 gold badges39 silver badges60 bronze badges

answered Apr 27, 2011 at 13:44

Pih

2,26415 silver badges20 bronze badges

Collectives™ on Stack Overflow

Adding new data to DB when using 2 tables

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related