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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

