12-12-2013 12:24 AM
I have two fields "Division" and "Assignment Group" in a custom made form.
Division is a text field and Assignment group is a drop down menu with value list $G.assignment.groups
In assignment file the Assignment group(name) is related to the division.
For example lets say division 1 has group A, B, C
and division 2 has group D, E, F
and so on.
Now when i click on the Assignment group dropdown its showing all the groups irrespective of the division.
How do I add a filter so that the assignment dropdown menu show the groups only related to the division?
Any help will be appreciated.
Also please have a look on the link mentioned below
Thanks and Best Regards,
Solved! Go to Solution.
12-12-2013 12:44 AM
$G.assignment.groups contains all the assignment groups without any filter. This is a Global list and build on startup. So how you gets the full list.
Now you need list based on your division so you should use query in select condition of assignmnet.gotup filed like below,
here assuming you have mentioned division name in each assignment group, so above will select groupname from assignment table where division value in file equals to division value mentioned on form (in field division form on your customized form)
12-12-2013 01:29 AM
Thanks for your feedback.
Tried runing the query but didn't help me.
Went to assignment.groups and under the Limiting SQL field wrote select("name","assignment","as.division","cust.div
where name and as.division are the attributes for group name and division field in assignment file.
cust.division is the attribute for the division field in my custom table(associated to my custom form I mentioned earlier).
Why is the "assignment" mentioned in the query? Is it pointing to the assignment table?
12-12-2013 01:35 AM
as mentioned by piku in previously, use this query on form with combo field and also use proper syntax
12-12-2013 03:07 AM
I am still not able to make it work.
Let me help you with what I have done.
Edited the Global list assignment.groups
List Name: assignment.groups
List Variable: $G.assignment.groups
Display Variable: $G.assignment.groups
List field: name
Display field: name
Limiting SQL: select("name","assignment","as.division",[cust.div
My custom form chgautoassignment
For the Combo Box Assignment
Input : cust.assignment
Value list: $G.assignment.groups
Having a hard luck with the filter here. Dont know where I am going wrong?
12-12-2013 03:33 AM
This is wrong. Do not put select statement in Global list.
Follow below steps:
open form "chgautoassignment" in form designer.
In Design mode, select a combo box remove Value list as $G.assignment.groups from combo box field.
Go to Value list condition properties and put
save twice and come out.
Access form and select cust.division field value in form. Then cust.assignment field value will populate based on cust.division.
12-12-2013 04:02 AM
Thank you so much Avijit.
It worked. Thanks again for the much needed help.
Can you please have a look at another issue that i have posted in the forum
Any help will be appreciated.
Have a good day.