Quick Multi Key Relationship Question.

[backsmith]

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

[Søren Dyhr]

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

[backsmith]

Thanks that was really usefull reading.

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

John

[Søren Dyhr]

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