A
Annette
I would like to relate words in a memo or text box field to another
table.
Table
Case (CaseID, CaseNo, Description)
People (CaseID, ShortName, LongName)
Fact (FactID, CaseID, Fact)
Let's say I have three people in the people table that are part of
case 123. AndersonA, MillerP and JonesS. All of these are short names.
I would like to create a fact for case 123 that states "AndersonA went
shopping with MillerP". I would like to "link" both AndersonA and
MillerP to this fact. If I have another fact "AndersonA went shopping
with JonesS", I would like to "link" both AndersonA and JonesS with
this second fact. Then if I were to query AndersonA I would see them
linked to two facts in case 123 and MillerP would be linked to one
fact in case 123 and JonesS would be linked to one fact in case 123.
I could accomplish this by using a combo box but feel the entry would
be duplicating the fact in order to assign to a new person.
I have seen this working in another database and when you are in the
fact field and typing your fact, the minute you enter AndersonA, it
appears as a hyperlink -- it even autofills the rest of the word once
you get to "Ande" and then of course links to the people table to the
AndersonA shortname record.
Facts are not long -- maybe would work with a text field too instead
of a memo field.
Any ideas?
table.
Table
Case (CaseID, CaseNo, Description)
People (CaseID, ShortName, LongName)
Fact (FactID, CaseID, Fact)
Let's say I have three people in the people table that are part of
case 123. AndersonA, MillerP and JonesS. All of these are short names.
I would like to create a fact for case 123 that states "AndersonA went
shopping with MillerP". I would like to "link" both AndersonA and
MillerP to this fact. If I have another fact "AndersonA went shopping
with JonesS", I would like to "link" both AndersonA and JonesS with
this second fact. Then if I were to query AndersonA I would see them
linked to two facts in case 123 and MillerP would be linked to one
fact in case 123 and JonesS would be linked to one fact in case 123.
I could accomplish this by using a combo box but feel the entry would
be duplicating the fact in order to assign to a new person.
I have seen this working in another database and when you are in the
fact field and typing your fact, the minute you enter AndersonA, it
appears as a hyperlink -- it even autofills the rest of the word once
you get to "Ande" and then of course links to the people table to the
AndersonA shortname record.
Facts are not long -- maybe would work with a text field too instead
of a memo field.
Any ideas?