Not sure if you still sail with Trevor, but feel free to use me as shark bait or an anchor out there anytime for self-amusement !!
From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Turner Sent: Friday, 30 October 2009 1:06 PM To: ozMOSS Subject: RE: SharePoint Custom List with column parent-child relationships I have done this with a custom field (if you're really nice to me I might give it to you). :) Nothing OOTB can do it in 2007 :( Regards, Paul Turner Senior Solutions Specialist M: 0412 748 168 P: 08 8238 0912 F: 08 8234 5966 A: 66 Henley Beach Road, Mile End SA 5031 E: paul.tur...@dws.com.au<mailto:paul.tur...@dws.com.au> W: www.dws.com.au [cid:image001.jpg@01CA5962.19609EB0] ADVANCED BUSINESS SOLUTIONS LTD This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Any opinion expressed in this e-mail may not necessarily be that of DWS Pty Ltd. Please consider the environment before printing this email. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of CARR, Matthew Sent: Friday, 30 October 2009 12:53 PM To: ozMOSS Subject: SharePoint Custom List with column parent-child relationships All, Is it possible using SharePoint out-of-the-box to define parent child relationships within two columns in a Custom List when using the default Create/Edit web parts? The clients design premise is to minimise application development and maximise the native functionality that exists within SharePoint. By way of an example to further explain this request I have defined the following reference lists Category list with column/values ID Title 1 Packaging 2 Ingredients 3 Finished Goods SubCategory list with column/values ID Title ForeignTitle 1 carton Packaging 2 pallette Packaging 3 paint Ingredients 4 plastic Ingredients 5 invoice Finished Goods For Data entry the client would like to raise Issues that have an associated category and subcategory defined. Hence I have defined a custom list called Issue with x number of columns including a Category ( this is of type lookup to the Category list) and a SubCategory column which would contain filtered values based on the Category value. Looking thru the Create Column definition component I can't see how one can set this to the subcategory lookup list and apply conditional/dynamic filtering based on the selected category value. Is this functionality available within SharePoint. Is there a trick, I can't see how parameters can be passed, how a calculated column or site columns can be used to facilitate this or concatenated columns can be defined Can this be done ? Cheers Matt
<<inline: image001.jpg>>
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
