Thank you for the great library. I'm having a bit of trouble and was hoping run my scenario by the community to get around this stumbling block. I'm attempting to create something I think is possible based on the documentation but I'm not seeing all my child
column values. Here is my setup:
- Products list.
- Functionality list.
- Issues list.
- Symptom List.
The symptom list will contain lookups to the other lists via site columns. The idea here is that a user will have a symptom they want to report. They'll go to the symptom list and will select a product. This product will be bound to multiple chunks of functionality
and it's up to the user to pick a single item that makes sense. The Issue List will be added to the symptom list via a site column that is a lookup. This issues list is static and requires nothing special. It could have been part of this list but
this way it can be reused more efficiently.
Take for example SPD 2007, it is a product and the functionality it has is a one to many relationship. Think: data view, workflow, css and so forth.
That is the part I'm having an issue. I've populated the products list with some data, again let's keep with something we're all familiar with, WSS 3.0, SPD2007, MOSS2007 and so forth. These values are stored in the title column.
Next, the functionality list is populated with data such as asp.net controls, CSS, workflows and so forth. On the products list, I consume the functionality list by adding an existing site column which is a lookup to the functionality list and it allows
for selecting multiple values. I can bind my single product to multiple chunks of functionality establishing a one to many relationship.
A list item in the products list will look something like this: SPD2007 > Asp.net, CSS, Data view, workflow. This can be done for various products.
Back to the symptom list which is the glue that binds this whole thing. The OOB listformwebpart is being used to create the symptoms. A few existing columns are added: Products, Functionality, Issue which all point back to the original lists.
I think this is where I'm doing something wrong. I created a new site column of the lookup variety and pointed it to the functionality list this way I'm not reusing the one that already exists which allows for multiple items.
This is what my markup looks like:
With this code I can select a drop down which contains all the products and I get only 1 of the multiple values stored in the child column.
In my example list item from the products list (SPD2007 > Asp.net, CSS, Data view, workflow) I only see asp.net but not CSS, Data view or workflow.
I think I'm just structuring my list incorrectly but I cannot think of a way to make this cleaner.