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
------------------------------
Original Message:
Sent: 01-21-2021 13:58
From: Blake Harrison
Subject: Creating dropdowns based on contains
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/
Original Message:
Sent: 01-21-2021 09:27
From: Aswin Babu
Subject: 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 in which values in drop down of A depends on value selected in B. But the relationship between A and B is A-<B (one A to many B) so the normal conditional dropdown method is not possible in my case. I want to know whether I can code like when a particular word in a column of A appears, show records with that word in a particular column of B.
Please let me know if this is possible.
------------------------------
Aswin Babu
------------------------------