Filemaker Pro 9 (64)

Question 1

This set entered on 5-16-14
5.5.14.1

1. p 347. PORTAL POWER. When you choose to have the RECORDS SORTED in a PORTAL, how are the RECORDS in the ORIGINAL TABLE AFFECTED?

Answer 1

NOT AT ALL. It has no effect at all on the RECORDS in the ORIGINAL TABLE OCCURRENCE. You can even put another PORTAL on a different layout and set it to use a different SORT ORDER.

Question 2

2. Normally, a PORTAL starts with the SAME RELATED RECORD. How do you change this?

Answer 2

Change the INITIAL ROW VALUE, and the PORTAL WILL SKIP SOME ROWS.

Question 3

3. Can you put the SAME PORTAL on your layout more than ONCE?

Answer 3

YES, you can even give it DIFFERENT INITIAL ROWS.

Question 4

4. If you make a PORTAL GROW VERTICALLY (WITH ANCHORS), how do you decide whether FileMaker adds MORE ROWS or JUST MAKES EACH ROW BIGGER?

Answer 4

If anything IN the portal is anchored on the BOTTOM, the PORTAL ROWS WILL GET BIGGER, otherwise, the rows stay the same height and more of them get added to the space.