Join tables in custom fields

Hi,

When you creating list of values for a custom field you have based it on a single view. Instead of that you can create new view as a  join of two other views and base your custom field on the new one.

Best Regards,

Pawel

Hi Pawel,

I am afraid I didn’t catch that. Do you have an example to clarify it?

Thank you and kind regards

Yes, for IFS Apps 9, when using the “Select” Implementation Type for a Read Only custom field, you can use any valid SQL statement, as long as it’s correctly bound.

Did you run into some issue when trying this out to see if it would work?

I believe Pawel is outlining your options when creating a persistent custom field that references a single view to determine what shows up on the list of values when the user chooses a value to populate the field.

Hi @Tracy Norwillo 

yes I had a problem in the past. But I found another way to solve it.

Thank you for replying.