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.