How to make a series minimizable text fields in one view pane, to.

[sadie32]

I am looking for a way to create a 'database' notebook of many
minimizable/expandable text boxes. The idea is to have one place to track
work done on numerous related tasks, and the minimized version of each
section should ideally show three lines: the title of the work area, date
last addressed (and by who), and next required task (with a due date).
Willing to try anything, but I'm a novice. This needs to be something I can
place on my organization's server for multiple accessors as a
password-protected type document. Due to the variation of duties, it does not
need to have special fields, so it is mostly a lineup of many note-pads that
can become short/small objects to allow viewing of the other notepads.

 

[Wayne-I-M]

Not sure what you are looking to create here.

I "think" you want a form that your work mates can open and then
add/edit/etc notes regarding some work tast.

If this is the case you will need to put a little more thought into what you
want and what the end result will be -

Database design tends to work backwards.
This is you do not just start adding data to a table and then see what you
can do with it. You should (as an example) decide if you want to store data
for a specific reason - then decide what the reason is (reporting, analsis,
etc). After this decide the format of the data then how best to accomplish
your requirements.

So.... If you want to store notes for workmates
You will need a table to store the notes
Will each person only have access (edit/read/etc) to specific notes or will
then be able to use all notes.
If the 2nd case is true you will need a table for employees - if you want to
record "who" alters the notes.
etc
etc
etc

Best idea would be to get a book on DB design and work thought it - well at
least the 1st section anyway. This will give details of DB planning which
needs to be done "before" you start to create the DB.

If you have a specific question on your design post it here and someone
should be able to help.

Hope this helps

 

[Damon Heron]

You might want to check out MS OneNote, rather than build something from
scratch.

Damon