Joe, Won't that give me the Parent record multiple times? I posted back to Matt that it's a Purchase tracking app. The parent is a Material Request and the child is the MR Line Item. One to many. Now each Line Item (child) can have a Purchase Order number. And that number can be used on many children of different parents. This is were I see it as many to many. I need to search for a PO number and return all of the Material requests (Parents) of the different Line Items(children) without duplicating the MR in a results list. There is a table filed to display the children of each parent. Thank you, 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
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, December 13, 2006 10:58 AM To: [email protected] Subject: Re: Many to Many Child-Parent search ** 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 <http://www.arslist.org/> ARSlist:"Where the Answers Are" ________________________________ Everyone is raving about the all-new Yahoo! Mail beta. <http://us.rd.yahoo.com/evt=45083/*http://advision.webevents.yahoo.com/m ailbeta> __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
