SQL INSERT with Inner Join

I Have a Table (Accommodation) with All information about a holiday home. Inc ID Name etc. I have another Table (Schedule) with a Schedule ID, Date and Price I have a final table to join the two (SchdAccom) with A schdaccom id, the AccomodationID and Schdule ID.

What this allows is me to add dates a holiday home is available for use by linking its id with an id of a date and 1 home can link with many dates/price.

Heres my issue I can query this fine no problem works开发者_运维百科 great but im unsure how to go about inserting new ones. For instance, at the moment you as an admin select the holiday home click a button to see the dates and a gridview pulls this info. I want to be able to add more dates but the tableadapter wont generate insert code.

Any idea on how to go about this?

---

The best method would be to generate SQL that would inject data into both tables when you submit the request. Because you're working with 2 different tables, you're going to have to write a bit of manual code.