Im migrating from FM5 so the new relationship optins are intriguing me.

DO you think it is better to use an AND relationship. Eg.

Date = Date

AND

ID = ID

or caluclate DATE & ID = NEWKEY in both tables

then relate

NEWKEY = NEWKEY

I guess my question is, is it better to have more calculated fields or a more complicated relationship chart? What are the advantages of either method.

Ive aready got the calulated keys fields from the FM5 application.

Thanks

John

The former....

Regarding the complicated graph, would I immediately guide you to reading about Anchor Bouy concept, since most TOG's doesn't have to be more than from 4 to about 15 TO'es tied together. Have a TOG for each layout...

I have a suggestion to a sequence to study the approaches in:

1) Watch this movie - http://www.filemakermagazine.com/videos/graph-rules-four-rules-to-remember.html

2) Read this text - http://www.fmp.it/download/files/FM7_key_concepts.pdf

3) http://fmprelationships.blogspot.com/2008/07/filemaker-anchor-buoy-segmentation.html

4) http://sixfriedrice.com/wp/six-fried-rice-methodology-part-2-anchor-buoy-and-data-structures/

--sd

Thanks that was really usefull reading.

Im going with the TO solution. No more calculated keys.

John

They shouldn't be completely ditched they still have their uses e.g. yesterday did i struggle to avoid the use of it here:

http://fmforums.com/forum/showpost.php?post/345753/

...if you should be able to see how it could be avoided here, would I gladly learn?

--sd