Sorry, it's SQL 2K.
Something like that is probably going to be my best bet. Our PMO's will need a way to access both forms simultaneously for end of year reporting anyway. Thanks much. Michael A. McManus, SrA, USAF Remedy Developer HQ 754 ELSG/DOOH DSN: 596-6478/Comm: 334-416-6478 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 18, 2007 9:05 AM To: [email protected] Subject: Re: Searching multiple forms You didn't specify what Database. What we did was to create a database view of the 2 tables unioned together and then create a reporting form (since you use incident and archive_incident the form could be report_incident) that is a view form of the database view Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SrA HQ 754 ELSG/DOO Sent: Wednesday, April 18, 2007 8:48 AM To: [email protected] Subject: Searching multiple forms ** Running ARS 5.1.2 The incident table in our application was becoming a bit cumbersome, so we created a stored procedure to archive records that have been closed with a last modified date greater than 180 days old. In extreme cases, our analysts sometimes reopen old tickets for various reasons. Currently, our advice to them is to search the incident form, and if the ticket isn't found there, to open our archive_incident form and search there. My functional would like me to create workflow that will allow our analysts to search both forms simultaneously. I know of one way to do this, but I'm curious if any of you know of a better, or different way. My suggestion was to create 2 table fields, one that populates from the incident form, and one that populates from the archive_incident form and refresh them based on analyst input (namely, an incident number). This works, but I'm up against a space constraint on the form in question, as well as a general resistance to change of any kind. I don't know of any other way to search two forms at the same time, but I figured if there was another way, this community would know about it. Thanks, Michael A. McManus, SrA, USAF Remedy Developer HQ 754 ELSG/DOOH DSN: 596-6478/Comm: 334-416-6478 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
