Hi, I’m relatively new to Database Design, and I’m using Dreamweaver MX 2004.
Anyway, here’s a link to my site:
http://ns107.webmasters.com/*wholistic.net/httpdocs/services_list.php
Basically you can see I have the database created and here are my 3 tables.
Table 1. tbl_service (all the services offered)
Rows (1. service_id Primary Key) (2. service_name) (3. service_description)
Table 2. tbl_provider (the providers of the service)
Rows (1. provider_id Primary Key) (2. provider_name)
Table 3. tbl_link (a table that links the two other tables together
Rows (1. link_id Primary Key) (2. service_id) (3. provider_id)
'k…So here what I can’t figure out how to do.
I need to be able to add a provider, and when the form to add the provider is submitted, the new formed Primary Key of the tbl_service and the Primary Key of the tbl_provider are inserted into the columns in the (tbl_link) { service_id and provider_id }.
Any ideas??
Thanks!!!
~Troitone~
