M, Thanks for quick response.
Essentially I've got a main list (TheMainList) which is where I need the cascade drop downs (NewForm, EditForm).
This contains two drop downs: -
DropDown1 - Containing values Bob, Marc and Fred (a lookup on List TheNamesList)
DropDown2 - Containing values A through to Z (a lookup on List TheAlphabetList)
I then have a relationship list (theRelationshipList) which again contains two drop downs: -
Parent - Containing values Bob, Marc and Fred (a lookup on List TheNamesList)
Child - Containing values A through to Z (a lookup on List TheAlphabetList)
For Example: -
My understanding is that 'TheMainList - DropDown2' should be a lookup on 'TheRelationshipList - Child' but the values aren't unique (too many A's), hence the requirement for 'TheAlphabetList'.
I'm hoping there's still a way of getting this working as there is still a link between 'TheMainList - DropDown2' and 'TheRelationshipList - Child', although via 'TheAlphabetList'.
Hope this makes sense