Re: [s2smedia] List Options from database - multiple tables
Hi there.
I took a look at your site and I think I see what you are aiming for. When you click to one of your academies, there is a part on each of those pages that is labeled "Session Schedule". This is where a list of locations needs to load right?
If this is the case, Dave's suggestion would work. You would create a new section called "Locations" and in that section you would have a drop down menu called "type" with each academy as an option.
From there, one each of your three pages, you would just need to add one extra line to the viewer code for each of your academy pages so that it loads the proper list of locations.
Let me know if that all still makes sense and we can go over the code in some more detail if you like
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/