Ian Vaughan wrote: >How could I display the correct menu options which are generated from the >correct cfquery based on the user logged in. > >So if the user logged in is from the personnel department the following query >populates the select boxes, but if the user logged in is from the finance >department then the finance query runs on the page to populate the select box. > >Can anybody see any flaws with this approach ? Or how it can be improved to >make the solution more flexible? > > Ian,
Are you saying that you have a separate category table for each department? Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54