D
Debug_Brooke via AccessMonster.com
I've spent a significant period of my Access learning adventures sifting
through threads on this site. I must say "THANK YOU!" to all who share your
vast knowledge! So now, I'll pose my current conundrum:
I have a database of contractual correspondence. There are many tables, it’s
normalized, no duplicate information, multiple queries and search forms.
Everything is great (thanks to all of you!), except our letters require cross
referencing with previous submittals. I need to be able to see one record of
a letter and all other letter records which relate to it, via the explicit
reference in the letter itself. The reference letter number is almost always
a previous record in the database; only on rare occasions is it "email dated
mm/dd/yyy," which would not be a record in the database.
Currently, I just have four textboxes set as Memo datatype (because sometimes
it can be up to 10+ letters referenced) under a “Cross Reference†tab on the
correspondence entry form. Unfortunately, this causes a lot of jumping back
and forth to locate cross referenced records. Granted, the search forms make
that easier, but I’d rather have the ability to see the key parts of those
reference letters when I review the record (e.g. Letter Number, Subject, Date)
. I’d also like to have the ability to retrieve the referenced letter
numbers when entering them (to avoid typos) into the new letter record.
This is highly important, even if I can’t see all the referenced letters on
one record, I need to be able to see all of the incoming/outgoing
correspondence for the particular matter even if it’s via a report or query.
This database covers five years of correspondence on a project with many
levels of contractual matters. It cannot be simply solved via topics, as many
topics are interrelated and often, in the initial stages of a
sending/receiving correspondence, we may not know what the topic even is at
the time (i.e. initial discussions in a string of correspondence could
ultimately result in correspondence submitting a proposal but you don’t know
that initially). Also, I already have a table with topics, proposals,
contract requirement references, and more; I actually need to reference the
letter numbers stated in the letter.
If you have any advice, I’d sincerely appreciate it. I apologize for the
length, just trying to cover all the things you might need to know!
I guess, the summary of my question is: how do I cross reference records (and
I guess I can’t have them auto-update the referenced records from what I
read on another thread – please confirm)?
through threads on this site. I must say "THANK YOU!" to all who share your
vast knowledge! So now, I'll pose my current conundrum:
I have a database of contractual correspondence. There are many tables, it’s
normalized, no duplicate information, multiple queries and search forms.
Everything is great (thanks to all of you!), except our letters require cross
referencing with previous submittals. I need to be able to see one record of
a letter and all other letter records which relate to it, via the explicit
reference in the letter itself. The reference letter number is almost always
a previous record in the database; only on rare occasions is it "email dated
mm/dd/yyy," which would not be a record in the database.
Currently, I just have four textboxes set as Memo datatype (because sometimes
it can be up to 10+ letters referenced) under a “Cross Reference†tab on the
correspondence entry form. Unfortunately, this causes a lot of jumping back
and forth to locate cross referenced records. Granted, the search forms make
that easier, but I’d rather have the ability to see the key parts of those
reference letters when I review the record (e.g. Letter Number, Subject, Date)
. I’d also like to have the ability to retrieve the referenced letter
numbers when entering them (to avoid typos) into the new letter record.
This is highly important, even if I can’t see all the referenced letters on
one record, I need to be able to see all of the incoming/outgoing
correspondence for the particular matter even if it’s via a report or query.
This database covers five years of correspondence on a project with many
levels of contractual matters. It cannot be simply solved via topics, as many
topics are interrelated and often, in the initial stages of a
sending/receiving correspondence, we may not know what the topic even is at
the time (i.e. initial discussions in a string of correspondence could
ultimately result in correspondence submitting a proposal but you don’t know
that initially). Also, I already have a table with topics, proposals,
contract requirement references, and more; I actually need to reference the
letter numbers stated in the letter.
If you have any advice, I’d sincerely appreciate it. I apologize for the
length, just trying to cover all the things you might need to know!
I guess, the summary of my question is: how do I cross reference records (and
I guess I can’t have them auto-update the referenced records from what I
read on another thread – please confirm)?