Field visibility by 2 tables condition

[gayatri38]

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.

[Dnyaneshwaree]

Please specify the relationship between both tables.

[gayatri38]

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

[Dnyaneshwaree]

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

[gayatri38]

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