When you want to display all records from a table in a portal, there are two ways to create the relationship; one of them is absolutely the wrong way to do it, The right way is to use a cartesian join and the wrong way, because it’s considerably slower, is to use a constant relationship with a calculated field (one) having a value of 1. I don’t know why it is slower but that isn’t important; knowing that it is, is.
Displaying All related records
by nautilusfm_muk48m | Jan 19, 2020 | Blog, FileMaker Tips, Quick Tips | 1 comment
Hello. This post was extremely interesting, especially because I was looking for thoughts on this topic last Thursday.