All posted... http://paulturner.is-a-geek.com
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: [email protected]<mailto:[email protected]> W: www.dws.com.au [cid:[email protected]] 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: [email protected] [mailto:[email protected]] On Behalf Of Paul Turner Sent: Friday, 30 October 2009 1:34 PM To: ozMOSS Subject: RE: SharePoint Custom List with column parent-child relationships I looked at a few of those early on in my dev too. I found that in certain circumstances they broke i.e. when source lists were deleted. The SPSolutions (http://tonybierman.com/blog/2008/07/17/free-custom-cross-site-lookup-column-add-on-for-wss-v3/ ) one is particularly bad when this happens and it doesn't support cascading. So I ended up building my own that could stand up to any kind of abuse a user/admin could do to it. No JavaScript either, totally server side. I'll put a blog post together tonight and post it with source code. 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: [email protected]<mailto:[email protected]> W: www.dws.com.au [cid:[email protected]] 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: [email protected] [mailto:[email protected]] On Behalf Of Daniel W. Brown Sent: Friday, 30 October 2009 1:13 PM To: ozMOSS Subject: RE: SharePoint Custom List with column parent-child relationships http://customfieldcontrols.codeplex.com/ has always worked for me. Parent/Child lookup columkns as well as a query based lookup field. Have used them with severasl clients now, works great. ________________________________ From: [email protected] [[email protected]] On Behalf Of CARR, Matthew [[email protected]] Sent: Friday, 30 October 2009 12:52 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 [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
