The db project I am working on has a unique serial number for each
do***ent.
The procedure calls for the orignator to send the do***ent forward to the
next department for further processing. If you consider a multi-part
form,
once it is separated changes can no longer occur. That is the same
process
we are using in the db. So what I want to do is allow the user to
reference
the original do***ent if they need to create a new do***ent to
correct/update
information on the orignal form. A one-to-one table most likely would
work.
What I would like to prevent the user from doing is selecting to reference
do***ent #2 from do***ent #4 instead of the original #1 do***ent.
So for an example, Doc-0001 is the original do***ent. Doc-0005 is issued
to
update Doc-0001. Then Doc-0014 later on is issued. Doc-0014 should
reference Doc-0001 not Doc-0005. I need to excluded Doc-0005 from the
reference list (since it is already linked to Doc-0001). Hope I painted
the
picture sufficiently. Suggestions would greatly be appreciated.
Dave
