Hello John, Have you tried creating an external view/join form using the unique constraint, and creating a view form from that? Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia.
----- Original Message ---- From: "Reiser, John J" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, December 13, 2006 10:13:23 AM Subject: Many to Many Child-Parent search Hello Listers, ARS 6.3 patch13 MS 2000 with remote MS SQL 2000 I am trying to get a list of parents that have the same children to display in the parent form. I push the Parent GUID to the child record. That child record has another GUID field for the Group in which it belongs, lets say an eighth grader. I want to pull back the list of parents that have eighth graders. I would like to do this from the parent form and show the results in the parent form. I have been able to get the first parent listed but no more. I know I could use a join but the design requirements are such that the parent record only shows once in the results list. The parent has a table field that lists its children based on the Parent GUID. I was thinking that I need to use an ALGuide and table walk but I am not sure how to make that spawn the dozen or so parent records. Any help would be appreciated. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________________ Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
