Create Database field

[Mohan Sundar]

Hi, I'm using PowerDatabase Pro plugin.

We have a custom field called SubModule where the field will fetch an information stored in TableGridEditor (Another Table Plugin) in that particular project and display it.

select iname from moduledetails_cxxxx where proj = {project} and istatus='Active' union select iname from apps_cxxxx where proj = {project}

This is the Database query we have used.

Now I have a requirement, I have a common project and in which I have a "project picker" custom field.
Just like the above database field, I want a field which should show the TableGrid information of the selected project in the custom field project picker.

Basically in the project picker if I choose a Project "TEST1" then the SubModule DatabasePro field should show the information of the "Table Grid" stored of the TEST1 project.