Dreamweaver MX - ASP - Databases

[EmmaGale]

I am setting up a database using Dreamweaver MX and Access. I can write to the database - and pull info from it.

I have a few problems and would be grateful for some pointers or relevant tutorials.

1. New records have the ID as the primary key and are set up as an autonumber. I would like to display this number as the users reference number when the new form either opens up or saves. Also is it possible to display blank fields as a form opens? At the moment there are fields being displayed.

2. The person I am helping to do this for wants users to log and and only have access to the records that are relevant to their department. So for instance if Emma Gale worked for the IT department as I logged in I would have only access to the records that were initiated by the IT Department. Is this possible?

3. Finally, there are two main database tables. Risk for the main records which can have one or many records connected to it (the actions). I am currently using Master Detail for the Risks. I view a summary of the Risks and can click to see corresponding detail for this on individual pages. That works well. What I now want to do is connect the second table to this. So for instance there, are 10 risks written to a page. I can click on one of these risks to see its detail. On that page, or a page which is connected to it I then want to see the associated actions of which there can be none, one or many. Hope this makes sense.

As I say - any relevant tutorials would be as good as someone providing me with the answers. I have looked at many but they dont seem to cover these aspects.

Thanking you all in advance!
Kind regards
Emma Gale

[Jerry]

you're looking for roles based authentication. What you should check is code for login systems, and then take a look at roles based permissions. (Not hard in this particular case.)

I doubt Dreamweaver can handle this on it's own. and everything else depends on the programming language you're using. (For instance, on ASP/IIS, I could write that permissions system in about 30 minutes.)

As for showing blank fields when the page loads, again, it's dependant on the login system you are using, and the language it's written in.

Hope this helps

[EmmaGale]

Thanks for the information you have given me it has been extremely helfpul.

I have now managed to find a way to logon that authenticates and then directs the user to a specific page.

The rest I am still looking for - but the important part has been dealt with.

with best wishes emma