I am new to Fabrik and have created a simple Contact Us with it. Very happy with the outcome and how simple it was to create.
I am now moving on to my next, more complicated task which is a salesperson locater. I'm struggling to understand the best design approach to implementing it and hope to get some input from the experts here.
My goal is to use a single dropdown that is populated from a table (which I have easily accomplished with a database join) which contains area information like US states or Canadian provinces. I then want to be able to filter the results of three separate lists 1) list of factory sales person(s), 2) list of representative(s) and 3) list of distributor(s)). Each list group data is unique, but they all have the same primary key which is the area id from the area dropdown. basically all three lists will only show the results that match the selected area from the dropdown.
So, I'm guessing I need three separate lists that can somehow be connected to a single form with the area dropdown. I have been trying to prototype the basic layout, but so far I have not been able to figure out how to bridge the gap between a form and a list, let alone three lists.
Any help getting this started would be greatly appreciated.
Tim
I am now moving on to my next, more complicated task which is a salesperson locater. I'm struggling to understand the best design approach to implementing it and hope to get some input from the experts here.
My goal is to use a single dropdown that is populated from a table (which I have easily accomplished with a database join) which contains area information like US states or Canadian provinces. I then want to be able to filter the results of three separate lists 1) list of factory sales person(s), 2) list of representative(s) and 3) list of distributor(s)). Each list group data is unique, but they all have the same primary key which is the area id from the area dropdown. basically all three lists will only show the results that match the selected area from the dropdown.
So, I'm guessing I need three separate lists that can somehow be connected to a single form with the area dropdown. I have been trying to prototype the basic layout, but so far I have not been able to figure out how to bridge the gap between a form and a list, let alone three lists.
Any help getting this started would be greatly appreciated.
Tim