Inserting records across multiple tables

[Iain]

I'm still pretty new to working with databases, but have been fine using Dreamweaver to add, edit and delete records from a flat table.

I'm less sure about updating records across multiple tables, for example in a one to many rleationship with a look up table, eg :

If I have three tables

Companies :
CompanyID (INT, auto increment)
Company
Address
etc

Contacts :
ContactID (INT, auto increment)
FirstName
LastName
etc

CompanyContacts :
CompanyID (INT)
ContactID (INT)

It's straightforward enough to create pages to insert new records into the Companies or Contacts tables using DW's Insert Record behavious, but how do I go about populating the CompanyContacts table when I add a new record in the Contacts table, so that it becomes 'attached' to a particular 'Company'?

If that makes sense.

Iain

[Piranha]

As said in another thread you should not have the table CompanyContacts in a one-to-many relationship. I suggest that you solve and understand that problem first and then try to solve this problem since they are depending on each other.

[Iain]

Cheers - from your other post, now that you mention it, I wasn't sure I needed the intelinking table - but I'd just gotten in the habit of structuring related tables like that in Access.

I'll try it out with the two tables and see what I can get displaying - although already it's sounding more straightforward as it would just mean entering the correct CompanyID when adding a new record in the Contacts table.

Iain