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
_______________________________________________
ozmoss mailing list
[email protected]
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

Reply via email to