I am using SharePoint Foundation and have created a parent and child list which both have a Title field. The child list has an additional lookup column to the parent list.
This enables me to enter data in the child list, and link it to the parent values.
I have a Document Library, and I'd like the user to first pick a parent value, then a valid child value when creating a new document.
Any pointers on how this can be achived? I've tried adding the Child list as a column on the doclib, but I can't choose to display the projected parent field. Or can it be achieved via a content type?