Searching for the use of a particular relationship in scripts, layouts, parameters, and everywhere used.

Troy Meyers's Avatar

Troy Meyers

17 Jan, 2018 06:06 PM

I've easily found where fields are used, but for some reason I haven't figured out how to find all instances of the use of a relationship. The two base tables are "Journal" and "Plant Tags" and the relationship I'm trying to find instances of is "Journal PHs for Plant Tags::". There are many other relationships between the two tables. I want to find all instances to that I can change some but not all to a different relationship.

I can find the relationship in the Relationships window (though I had a hard time seeing the proper field to search in) and it shows a link for Dependencies but not References.

Am I looking in the wrong place?

  1. Support Staff 1 Posted by Vince Menanno on 17 Jan, 2018 10:41 PM

    Vince Menanno's Avatar


    Prior to FM 7 relationships were a thing. But since version 7 Relationships are kind of a passthrough.

    Yes we have DDR IDs of relationships but those are never referenced anywhere.

    So if you are on

    Table A —> Table B —> Table C —> Table D —> Table E

    And you want to know if and when you are using the relationship between Table C and Table D … that is a hard one … I’ll have to give it some thought

    Probably doable if you have calculations to know that it comes from one context and traverses that relationship … not something that I have done currently

    And probably impossible to know if you have a script and manipulating data as the script could be using indirection and you would never know that it is traversing data using that relationship.


  2. 2 Posted by Troy Meyers on 18 Jan, 2018 05:24 PM

    Troy Meyers's Avatar


    Thanks for the quick reply.

    I'm actually not talking about anything particularly esoteric, and if I had said "table instance" instead of "relationship" this would have been clearer. The things I'm wanting to search for are disclosed on the HTML DDR what that is generated. I've attached a few screen shots to show some of the disclosures. I could continue to use the HTML DDR but I had hoped that InspectorPro would have a much better way to examine these. The trouble with the HTML version is that the database structure is so complex that Safari uses gigabytes of memory to display it, an it's sluggish (and even has the "This webpage was reloaded because it was using significant memory" warning displayed) even though I've got 24 GB of RAM.

    So, to recap, the relationship/table instance that I'm wanting to be able to examine and change in some places, in scripts, layouts, calcs, etc., is "Journal PHs for Plant Tags".

    Please take a look at the screen shots, see if you can suggest how I should find these in InspectorPro.


  3. 3 Posted by Troy Meyers on 18 Jan, 2018 05:29 PM

    Troy Meyers's Avatar


    Maybe I accidentally answered my own question. I looked in InspectorPro under "Tables" rather than Relationships, and found that the table instances are all in there, not just Base Tables, and sure enough all the references for "Journal PHs for Plant Tags" are linked to!

    I guess my problem is that I've been using FileMaker since FileMaker II and am self-taught so the changing meanings of some of the terms have not been obvious!


  4. Support Staff 4 Posted by Vince Menanno on 20 Jan, 2018 05:29 PM

    Vince Menanno's Avatar


    I hear you.

    I should have mentioned that also - sorry about that.

    But glad you found it.



  5. jay_g closed this discussion on 06 Aug, 2019 08:23 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac