Hi,
I am having some trouble; I have four tables in my database:
Project (project_id, title)
Staff (Staff_id, Name)
Access (Access_id, Access Level)
PSA (Project, Staff, Access) - (PSA_id, Project_id, Staff_id, Access_id)
I have created a form using Dreamweaver and I am able to create a connection with the database etc the only problem I am having is inserting a record. There are two tables which need to be updated when the form is submitted - project and psa.
The project table is simple, all that needs to be updated is the title of the project. The issue occurs with the PSA table as this may have 1 record added or up to 20 as there can be different amount of users on each project.
Also the project_id needs to be input in to the PSA table, the problem is that I have set it to autoincrement so there is no field displaying the project_id for the PSA table to pick up. A typical input might be:
project title - testing (id-3)
username - Pam (id-2) Access Level - Tester(id-4)
username - john (id-3) Access Level - Developer (id-5)
so I need the title 'testing' to go in to the project table, two records need to go in to the PSA table:
project id - 3, staff_id - 2, access_id - 4
project id - 3, staff_id - 3, access_id - 5
Any help would be great,
Pam
hardware
prices 
