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!