From: Colebean on
I am creating a document control system for standard operating procedures. I
have the tables set up and forms created for CREATE, SUPPLEMENT etc. I need
to create a user interface so that when they open the database it pulls up a
form that has CREATE, SUPPLEMENT, etc. When they click the SUPPLEMENT button
(for example) I want it to prompt them "new record" or "modify existing". If
it is new it would search for the document and add .01 onto the version
number and archive the previous version into an archive table. If it is
modify it would search for the most current version and allow edits. Then I
would also like to have a view all publications where they can't edit. I
have spent HOURS and HOURS trying to figure this out, if anyone could please
help me I would GREATLY appreciate it!!