Document ID Field - Reference qualifer

mangesh9
Mega Contributor

Hello,

Can we have reference qualifier for Document ID field so that only specific tables should be populated in 'Table Name' field in Select Document Window.

Thanks in Advance.

1 ACCEPTED SOLUTION

Hi Mangesh,



I understand. to filter that table you need to go to the dependent table name's dictionary entry and add the attribute tableChoicesScript that calls a script include function. See the dictionary entry for sys_dictionary.choice_table as an example.



It points to a script called DictionaryChoiceTables


find_real_file.png


find_real_file.png


View solution in original post

15 REPLIES 15

I have Document ID type field


Hi Mangesh,



The document ID field needs a dependent field of type table name. The table name field has an attribute as described above.



I hope that made sense. There are plenty of document ID fields in the dictionary to use as examples that have dependencies on table fields.


In the very beginning I used dependent field but it shows all the tables, in Table name field of pop up window


Hi Mangesh,



I understand. to filter that table you need to go to the dependent table name's dictionary entry and add the attribute tableChoicesScript that calls a script include function. See the dictionary entry for sys_dictionary.choice_table as an example.



It points to a script called DictionaryChoiceTables


find_real_file.png


find_real_file.png


Hi ctomasi,



Awesome...!!!!!!!!!!!!!!!!!  


Worked, Big Thanks..!!!



Cheers