AnsweredAssumed Answered

Finding out if a record is related to a specific record?

Question asked by 5eppa on Aug 6, 2018
Latest reply on Aug 6, 2018 by 5eppa

I am wondering what the best way to tell if a record is related to a specific record in a separate table in which there would a couple of other tables in between. This would need to evaluate to a true or false so as to define whether a button is visible on a certain layout or not. The relationship would look something like follows.

 

Table A is many to one to Table B which is one to many of Table C which is many to one to Table D.

I need to be on Table A and see if Table D::Field is equal to "string."

 

I am not sure if this can be done in Filemaker using anything built in or not. If not then maybe using Execute SQL will work.

Outcomes