tag:beezwax.tenderapp.com,2010-10-12:/discussions/inspectorpro-5/957-searching-for-the-use-of-a-particular-relationship-in-scripts-layouts-parameters-and-everywhere-usedBeezwax: Discussion 2019-08-06T08:23:47Ztag:beezwax.tenderapp.com,2010-10-12:Comment/445292102018-01-17T22:41:59Z2018-01-17T22:41:59ZSearching for the use of a particular relationship in scripts, layouts, parameters, and everywhere used.<div><p>Troy,</p>
<p>Prior to FM 7 relationships were a thing. But since version 7 Relationships are kind of a passthrough.</p>
<p>Yes we have DDR IDs of relationships but those are never referenced anywhere.</p>
<p>So if you are on</p>
<p>Table A —> Table B —> Table C —> Table D —> Table E</p>
<p>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</p>
<p>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</p>
<p>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.</p>
<p>Vince</p></div>Vince Menannotag:beezwax.tenderapp.com,2010-10-12:Comment/445292102018-01-18T17:24:27Z2018-01-18T17:24:29ZSearching for the use of a particular relationship in scripts, layouts, parameters, and everywhere used.<div><p>Vince,</p>
<p>Thanks for the quick reply.</p>
<p>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.</p>
<p>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".</p>
<p>Please take a look at the screen shots, see if you can suggest how I should find these in InspectorPro.</p>
<p>Troy</p></div>Troy Meyerstag:beezwax.tenderapp.com,2010-10-12:Comment/445292102018-01-18T17:29:55Z2018-01-18T17:29:56ZSearching for the use of a particular relationship in scripts, layouts, parameters, and everywhere used.<div><p>Vince,</p>
<p>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!</p>
<p>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!</p>
<p>Troy</p></div>Troy Meyerstag:beezwax.tenderapp.com,2010-10-12:Comment/445292102018-01-20T17:29:51Z2018-01-20T17:29:51ZSearching for the use of a particular relationship in scripts, layouts, parameters, and everywhere used.<div><p>Troy,</p>
<p>I hear you.</p>
<p>I should have mentioned that also - sorry about that.</p>
<p>But glad you found it.</p>
<p>Best</p>
<p>Vince</p></div>Vince Menanno