I don't think it matters. You can choose any field. I have not tested it, but it should work and should be easy for you to test. I would choose RequestID as the join criteria and an inner join.
On Jun 9, 4:41 pm, SUBSCRIBE arslist Melissa <melissa.r...@stls.frb.org> wrote: > What would you use as the join critieria? > > jham36 <jha...@gmail.com> > Sent by: "Action Request System discussion list(ARSList)" > <arsl...@arslist.org> > 06/09/2009 03:39 PM > Please respond to > arsl...@arslist.org > > To > arsl...@arslist.org > cc > > Subject > Re: Archiving and reporting/searching? > > How about a join form between the live data and the archived data? > Perform all searches and reports against that. > > James > > On Jun 9, 3:32 pm, SUBSCRIBE arslist Melissa<melissa.r...@stls.frb.org> wrote: > > We are starting to look into how to handle archiving and are running > into > > road blocks with how to be able to search/report on all the data, but > > still archive old data. What are other organizations doing? Does > anyone > > have any white papers or such they can share? We are using ARS 7.1. > > > TIA! > > Melissa > > _______________________________________________________________________________> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers > > Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"