I have 3 SQL tables. "Documents", "Departments" and a link tables to provide a one to many relationship (A single document can be viewed by many departments).
I have made a form that allows the addition of Documents whilst selecting the relevant department(s).
For the administrator I'd like to display a datagrid containing the list of documents, with dynamic columns that include every department. Ideally each cell will have a checkbox, thus allowing easy adjustment of document access rights.
If anyone can point me in the right direction I'd be happy person.
I have made a form that allows the addition of Documents whilst selecting the relevant department(s).
For the administrator I'd like to display a datagrid containing the list of documents, with dynamic columns that include every department. Ideally each cell will have a checkbox, thus allowing easy adjustment of document access rights.
If anyone can point me in the right direction I'd be happy person.