Hi Wayne,
Indeed, what Valentina wrote above.
It depends on how you manage your categories and ags.
If the assignment group can have only one category assigned to it, then add a reference category field to the assignment groups table (where you have all of your assignment groups).
If an assignment group can appear in more than one category, then you will need a new table where you can specify what's connected where.
Re the reference qualifier, you will probably need to add it to the assignment group dictionary override ref qualifiers and not directly to the field itself, as it is a global field. You will then be able to add a reference qualifier that looks a lot like a simple query or use something like:
javascript:'assignment_group='+current.category
So I think the first question would be - is it a one ag-many categories or one category-many ags relationship ?
harel
Edit:
Added a category field called u_inc_category on the group [sys_user_group] table and configured a category for several groups.
Configured the following Dictionary Override ref qual (table incident): javascript:'u_inc_category='+current.category
I have created a 'Query' form designed to be used by different areas of the business. The 'Category' defines the business area, e.g. Programme Finance. Within Programme Finance there are 10 teams, identified as Assignment groups. The requirement is when Category = Programme Finance, the only values available in Assignment group are the 10 teams associated to that business area. If the Category changes to Supply & Logistics, the teams available in Assignment group only relate to the business area of Supply and Logistics. Hope that makes sense.
