walkerc

Hi vitalikssssss, Please see screen shot, I haven't got a relation between the Contractor_Data and Main_Data (Orchard) the only relationship would be the Trading_Name = Contractor_1, 2 or 3 Regards Chris

Hi vitalikssssss Thank you for your help, I have created the data page exactly as suggested, filtering data based on auth field from Contractor_Data using Trading_Name as the matching record. This now gives no results??? I have double checked and everything is exactly right and in my mind should work as expected. Kind regards Chris

Hi, apologies but not sure my title explains exactly what I'm trying to achieve! I've got 2 tables - Main_Data and Contractor_Data, I've then created a details data page where I have included 3 drop down fields. The user can then select a Contractor (TradingName) using the drop downs from the Contractor_Data table which then become Contractor_1 in the Main_Data table, the same then for Contractor_2 and Contractor_3 - this all works fine. So I have created a view so each contractor can log in to see their respective jobs, I have linked the tables using Contractor_Data.TradingName = Main_Data.Contractor_1, this also works fine - Contractor_1 logs in and can see all the jobs under Main_Data.Contractor_1. Now the problem I'm having and hope that you might be able to help with, the jobs where we allocate more than 1 contractor (total of 3 on any one job) those contractors are unable to see their jobs as the view is only linking Contractor_1 so I added to the view - Contractor_Data.TradingName = Main_Data.Contractor_2 and Contractor_Data.TradingName = Main_Data.Contractor_3 and in the criteria tab set them as OR thinking that whatever position the contractors TradingName appears he should be able to view those jobs. The result I get is 'No Results' unless I enter the same TradingName in all three fields. What I want to achieve is that a contractor can log in using TradingName in auth field and then see all jobs allocated to them irrespective of whether they are either Contractor_1, 2 or 3 Hoping I've made sense?

Hi, I've created collapsible sections in my details page. However what I would like to achieve is when the user opens a collapsible section it automatically closes any other sections (if they are open)