Forum Discussion
BlakeHarrison
Qrew Captain
If your relationship is setup so that A < B, why do you want the user to select the B record first when building a record on Table C? If you select an option from Table B, and B is related to only one record in Table A, there will be only one option in the Table A drop-down. If you can provide a bit more context (and some real examples of the data in the two tables) your request may make a bit more sense, but so far, it doesn't.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
AswinBabu
4 years agoQrew Member
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
------------------------------
- BlakeHarrison4 years agoQrew CaptainYes, 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/
------------------------------
Related Content
- 2 months ago
- 28 days ago