I have an old friend in the Filemaker biz, one of those Amadeus types who assimilates everything Filemaker develops at the maximum level of potential, but I have since fallen out of touch with him. WHERE can I find guidance on sophisticated relationship structuring as relates to separating data from interface or even running calculations through separate relationships (to maximize performance and modularity) :?

Anything here in the forum? books? other websites?

Thanks in er..."advance" for your help.

Here is as good a place as any and better than most, although if it is sophistication you are looking for I won't be involved in many of your post .

There are many others here who share your friends passion for optimisation combined with elegance. All you have to do is ask

HTH

Phil

Inky Phil, while I completely appreciate your response, I was wondering where within FM Forums can you find Relational Structuring advice? More specifically are there any examples to download and examine? I have a solution Ive been working on for a while that I would like to optimize.

The best way is usually for you to try and build a simple file yourself, then ask questions about it, uploading the file so we can examine and possibly fix. It is best to do this early, before you build it all up.

There are lots of general examples about relationships; in fact most files uploaded here have something about them.

I haven't looked in the Separation Model forum in a while, but it sure helped me think through a number of issues around separating data and content. It's in http://fmforums.com/forum/showforum.php?fid/20/keyword/separation/

Also, I seem to recall some white paper out about the separation model, but can't put my fingers on it.

David

For interesting perspectives on data structures, I'd recommend Excelisys' hierarchal portals , Stark's Recursive Data Structures and Theo Gantos's Adatasol podcast appearances.

Not a lot to do with TSM specifically.

Edited March 6, 200817 yr by Guest