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 <[email protected]> wrote: > What would you use as the join critieria? > > jham36 <[email protected]> > Sent by: "Action Request System discussion list(ARSList)" > <[email protected]> > 06/09/2009 03:39 PM > Please respond to > [email protected] > > To > [email protected] > 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<[email protected]> 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:[email protected] ARSlist: "Where the Answers > > Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
