How do I filter on both parent and a child

[michaelrodway]

I have the following situation:

Employee:

-Name

-Status

...

Certificates:

-ID

-Name

-Employee (Reference to above table)

On a separate request form, we are selecting an employee to save in the form.

The default reference functionality is fine as they need to be able to select anyone, but we would like to also provide the end user with a more guided search: ie. We would like to be filter out those employees with a status of "Ready", who have a certificate with the Name "H2S". Search parameters depend on the request form.

I've been able to create a custom UI Macro with help from this post.

The easy part is querying just the employee table, the trickier part is including the cert query (is a database view needed, is this even possible)?

Does anyone have any recommendations?

[Abhinay Erra]

Michael,

    We can achieve this by using a reference qualifier. What do you mean by " Search parameters depend on the request form." Do they change based on the values selected by the user. Please elaborate on your requirement.

Thanks,

Abhinay

Please mark Helpful, Like, or Correct depending on the impact of the response