Relationship Graph In browse Mode

[Nemo]

Has anyone ever seen and/or heard about a calulation or script enabling you to edit the relationship graph in browse mode?

[Ender]

Huh?

Editing the schema has nothing to do with the mode you're in.

[Nemo]

We went to a DigFM meeting at FileMaker Corporate last night, and Michael Harris decribed a way to use the evaluate function as well as global identifiers to make "soft" relationships which could be changed on the fly in browse mode.

Goto www.digfm.org to check out his whitepaper, it was pretty cool.

[comment]

Relationships can be changed only in 'Define > Database... > Relationship'. In Browse mode, you can change the contents of match fields. That can affect, sometimes drastically, the contents of the related set/s. But the relationship itself is unaffected - it will always connect the same 2 TO's, using the same criteria.

[Nemo]

Not so, by defining a global field which populates from a value list containing refrences to all the other fields within each table you can literally change your relationship on the fly, and relate almost any bit of info to any other.

True there's more thought needed to design a solution based on this but it's a brilliant idea in my opinion, none the less.

You can check out video of the Sep 13 meeting here, under the title Softpaths.

http://www.digfm.org/meet1.php3?pg=9&pg2=19

Edited September 20, 2006 by Guest

[comment]

You can populate a field using any method you like - I don't see how that would affect the relationships graph. By placing calculation fields using the GetField() function in a portal, you can also dynamically change the source fields for the data shown in the portal. But the data is still coming from the related set in the predefined TO.