For each layout based on a different table occurrence than your original set up, you may need to define a) a new relationship and b) a new conditional value list that uses that relationship.
Say that in Companies, you want to Select a value in Companies::Sector in order for the value list in Companies::Industry to display only industries that are a part of that sector.
Define a new relationship between companies and and a new occurrence of sectors:
Companies::Sector = CompSectors::Sector
Then define a new value list that lists values from CompSectors, starting from Companies.
Thanks a lot for the response, I really appreciate it. I have been experimenting around with it, to no avail. But I have a feeling there probably is just one simple thing I may be overlooking. So, I will continue to try and get it in order. Thanks again for the response.
Feel free to post exactly what you have set up, the value list, the relationships, the layouts (and their specified table occurrences) if you want an extra pair of eyes to look over your set up and see what went wrong.
You can also download and examine this conditional value list demo file: http://www.4shared.com/file/f8NsU2DJ/ConditionalValueListDemo.html
Thanks for the help. I went through your demo file thoroughly and realized where I was going wrong. Rookie mistake. I had my relationships and table occurrences quite off. But I simplified everything and started from scratch, and it is working like a charm! Thanks again for all your help! I really appreciate it. It was driving me nuts.
Hello I've tried to download a demo file but site didn't let me unless I log in with some social network. Is it please possible to move the file somewhere where it's downloadable without registering?