If I understand you correctly, both forms have "related ticket number" (Request ID, I presume, in your REQ form). If this is the case, you could create a join form from the combination of REQ and TRN, using "related ticket number" as the key (join criteria).
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]
LIST.ORG To: [email protected]
Sent by: "Action cc:
Request System Subject: Searching Search
Idea!!!
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
06/05/2007 12:06
Please respond to
arslist
Hi List,
To create a ticket we retrieve some info from an external DB by SQL query
say "device number" When saving ticket we don't save this device info in
REQ form, instead we save it in TRN Form with related ticket number.
Now I need to show all the tickets associated to a Device in REQ form. I
did it in Table field but they want to show this info in result pane not in
table field.
I could not think of any other idea how to perform this search?
any help please??
Thanks in advance
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
<<inline: graycol.gif>>
<<inline: ecblank.gif>>
<<inline: pic10208.gif>>
