Creating dropdowns based on contains
I have 3 tables and in the child table, I want to have a conditional dropdown kind of behaviour. Let tables be A,B and C. A-<C(one A to many C) & B-<C (one B to many C). I want conditional drop down i...
Forum Discussion
Let the tables be Material Mix, Groups and Items. Material Mix<Items and Groups<Items. Groups have different records like High Quality Leather, Low Quality Leather, High Quality Polyster, Low Quality Polyster etc. The examples for records in Material Mix are Leather India, Leather Pakistan, Polyster India, Polyster Pakistan, Jute India, Jute Bangaladesh etc. so when I select group High quality polyester I want to see in drop downs records of Material mix Table like Polyster India, Polyster Pakistan. it's not possible through normal conditional drop downs technique since selecting group in form in Items initially is a must in our case.
Is there any way to make this possible though creating an additional table with just material name like polyester, jute etc only and use it to find records with that name in Material mix
Please guide me
------------------------------
Aswin Babu
------------------------------
Is there any way to make this possible though creating an additional table with just material name like polyester, jute etc only and use it to find records with that name in Material mix
Please guide me
------------------------------
Aswin Babu
------------------------------
Yes, the only way you can do what you're wanting to do is to have another table for Materials (Polyester, Jute, etc). For this setup, you'll probably want your structure to look like this:
Raw Materials would be Leather, Polyester, Jute, etc. Materials would end up being what you're calling Items (the name doesn't matter, though). In that Materials/Items table would be where you would set up your Conditional Drop-Down fields. Your users would first select the Raw Material and then drop-downs for Material Groups and Material Mix would be dependent upon the Raw Material selected.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Raw Materials would be Leather, Polyester, Jute, etc. Materials would end up being what you're calling Items (the name doesn't matter, though). In that Materials/Items table would be where you would set up your Conditional Drop-Down fields. Your users would first select the Raw Material and then drop-downs for Material Groups and Material Mix would be dependent upon the Raw Material selected.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
