Hi Joe, Thanks for the reply. This "create a view containing distinct values of B" sounds intriguing. Is that something I can do with Dev Studio or do I have to create that directly on the DB? I didn't see anything in the view properties in Dev Studio.
Thanks. Larry On Wed, Aug 21, 2013 at 4:06 PM, Joe D'Souza <[email protected]> wrote: > ** > > It appears like you are looking for a join between A and distinct of B, > which is only possible if you customize your system such that you actually > create a view containing distinct values of B, and then use that to create > a join with A.**** > > ** ** > > Otherwise as far as the AR System is concerned that second or third or > fourth row it might see of 100 if you had that many, are separate rows. No > way for it to know that you are seeking for distinct values.**** > > ** ** > > Joe**** > > ** ** > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *L G Robinson > *Sent:* Wednesday, August 21, 2013 2:14 PM > *To:* [email protected] > *Subject:* Join form question**** > > ** ** > > ** **** > > Hi Folks,**** > > ** ** > > I need some help with a join. I'm not sure if this is possible or not.**** > > ** ** > > In simple terms, I have two forms, Form A and Form B**** > > ** ** > > They have one field in common, lets call it X.**** > > ** ** > > Form A has the following values for X:**** > > 100**** > > 200**** > > 300**** > > ** ** > > Form B has two fields X and Y.**** > > There may be multiple entries in Form B where X is repeated:**** > > ** ** > > X Y**** > > 100 20**** > > 100 20**** > > 100 30**** > > 200 30**** > > 200 30**** > > 200 40**** > > 300 20**** > > ** ** > > Is there a way to join these two forms together so that if I search for > Y=20 I will get this:**** > > ** ** > > X**** > > 100**** > > 300**** > > ** ** > > instead of this:**** > > ** ** > > X**** > > 100**** > > 100**** > > 300**** > > ** ** > > I have tried a number of variations on inner/outer and switching primary > but I haven't been able to get what I want.**** > > ** ** > > Thanks for any suggestions you may have.**** > > Larry**** > > ** ** > > ARS: 7.6.04 SP3 201201302357 on Solaris 10**** > > Oracle 11.2.0.3.0**** > > ** ** > > ** ** > > Larry Robinson**** > > Remedy Developer/Admin**** > > NC State University**** > > Raleigh, NC**** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

