Selection List to choose items to update

[Guest]

I have built a database to handle revisions of our manuals. Currently when
you want to list items being revised, you select the manual and then choose
one document at a time from the list and enter it's new revision number and a
description of what was being revised. This is quite cumbersome.

What I would like to do is choose the manual and have the form (or another
form) display a list of all the documents that are in that manual. Then, be
able to just enter (in the description field for each item) enter the change
details for each item being edited. How would I create this form and make it
understand that in the "history" it's storing, that only those items I've
entered a revision description for should be logged as part of the manual's
current revision? Also, how can I get the revision number to increase itself
by one from that particular document's last revision number?

To anyone who is willing to tackle this mess... THANK YOU!
Jessa

 

[Guest]

Assuming you have a table for manauls and a child table for the documents,
this will not be hard. If you have everything in one table, you don't have a
database, you have a spreadsheet.
Tell me about your table structure.
I need the table names, the names of the fields involved, and for certain
the name of the revision number field.
Please be sure to note which table the fields are in.

Hopefully, your data is correctly modeled. If so, this will be easy. If
not, it will not.