Reference qualifier on a reference field based on another reference field

[mitzaka]

Hi SNC,

Can anyone help me out construct my reference qualifier for the following case:

* I have a table which has two columns - a string, and a reference field (to the same table, like a parent field).

* on the task form, I have two reference fields (first for Category, and the Second for Subcategory)

* I want to place a record producer on the second field (Subcategory), so that it will only show the records which have the Category (first reference field selection) as a parent

I tried with dependent fields, but it wont' work as I think I am in the many to many case.

So I think what I need is some script include and an advanced reference qualifier on the second reference field.

If anyone has done that please share.

[mitzaka]

aci@asp - what is the '?' in your syntax doing (I mean in what you proposed below)

javascript:!gs.nil(current.category) ? 'parent=' + current.category : '';

sorry for the question, but I am still struggling to get this working...

so my parent field on the form is: u_task_category (and is a reference field)

my child field on the form is: u_task_sub_category (and is a reference field)

the name of the categories in the table which I am referencing is under the table column named: u_category which is a string

the name of the parent category in the table (which apears to be the Category in the form later) is under the column named: u_parent_category and is a reference field to the same table

can you please let me know what the reference qualifier would look like in the correct syntax with my values?

greatly appreciating your help (this qualifier is annoying me already...)

[Abhinay Erra]

Hi mitzaka

Put this in the ref qual section of the sub category field dictionary

javascript:'<parent category field name goes here>='+current.<category field name on the form>;

[DilipKumar DJ · Accepted solution]

Hi Dimitar,

You should try below line in the ref qualifier of Task Table   subcategory field. Assuming pcategory is the field name of parent category in your custom table.

javascript:'pcategory=' + current.category;

[mitzaka]

dilipdj - dude, you rock:) this solved it all. I can't believe I was in so much trouble for such a short line of code...thank you, and all of you guys who are watching this thread in the community instead of doing something else on Sunday

[Abhinay Erra]

LOL man, isn't that what I said