Sep 17, 2010 at 3:47 PM
Edited Sep 17, 2010 at 4:11 PM
I think i know the answer to this one. I was hoping to use your library to set cascading dropdowns, but I am not sure I can.
My situation is, that having given up on the OOTB staff Search I am writing my own, using SPD and limited skills, taking the data direct from the SQL tables, into MS Access, building a staff list and a 3 tier structure (CEO>Directors>>Plebs) (and
doing lots of cleaning as our AD data comes from our HR system, which has certain limitations. Then i am pushing these data into a SharePoint List.
Therefore I don't believe I can set any columns in the lists to be lookups to a parent, and still be able to append the data from my Access area.
<edit>Ah I have been able to set the LookUp Columns in my child lists via Access, I needed to use the ID of the Parent rather than the content, so let's see If I can get this to work</edit>
I know this sounds convoluted, but given a) the data I have to work with and b) my limited skills it seems to work. I can get a basic department>>Staff lookup working, but I need those other levels in cascadeing boxes.
Sorry if none of this makes sense.
Any ideas if I can do this?
<edit2>Not sure this is for me - I simply want one cascading dropdown on a custom page (so not a list view page) that then can be used to query a third list - I think I may well end up doing it in vbscript - which I am happy with) and embedd the page
into my SP pages</edit2>