Field visibility by 2 tables condition

gayatri38
Giga Guru

I have a custom table called "file_route" which has data direction field and a newly created field called security exception. I also have a other custom table called "domain" which has 2 fields which is a checked true/false fields called personal info, health info. Here I want to display security exception when data direction in file_route table is 'inbound' and either personal info or health info is checked.

6 REPLIES 6

Dnyaneshwaree
Mega Sage

Please specify the relationship between both tables.

Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!

Dnyaneshwaree Satpute
Tera Guru

gayatri38
Giga Guru

It is one to many relationship, 1 file can have many data domains

 means that the domain is referenced from file route table right?

 

Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!

Dnyaneshwaree Satpute
Tera Guru

gayatri38
Giga Guru

 there is no unique reference number for file route or data domain, but we have the file route name in the data domain record.