Skip to main content

Timeline for Cascading Lookup columns

Current License: CC BY-SA 3.0

6 events
when toggle format what by license comment
Dec 10, 2014 at 21:17 comment added Keon I tried the steps above. I have another question. Where do I put the lookup column for the writing and editing lists? The list are related to the Assignment Category. If writing is selected in the assignment category, then they would get the choices from the writing list and same for the editing list. Or should I just put the choices from each list on the Assignment Category list and then set that as lookup column on the main list? By the way, the Assignment Category and Assignment Type switched data.
Nov 13, 2014 at 21:22 comment added Jordan Edited answer to add steps for you to follow.
Nov 13, 2014 at 21:22 history edited Jordan CC BY-SA 3.0
Added more steps
Nov 13, 2014 at 21:11 comment added Jordan So you would use the same list you are using as your main form. You will have to create two new lists if you want to have a cascading relationship between 'Assignment Category' and 'Assignment Type'. The first of those lists being just Assignment Category with just the title field of each different category. The second list would be of Assignment Type. This list will have two fields, title and a lookup to the Assignment Category. Then you will add lookups to your main list as your fields and place the script in the NewForm.aspx file. Does that make sense?
Nov 13, 2014 at 21:07 comment added Keon What would be the main form? Would the list that would be next to the relationshiplist the main form? In addition, there are other columns that would need to be added to the form. I would like to add those columns to the main form.
Nov 13, 2014 at 20:16 history answered Jordan CC BY-SA 3.0