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

