Filemaker Pro 9 (67)

Question 1

This set entered on 5-16-14.
5.5.14.4.

1. Add a PORTAL to the INVOICES LAYOUT using the PORTAL TOOL. The PORTAL SETUP dialog box shows up. What choices do you make?

Answer 1

a. Show RELATED RECORDS FROM: LINE ITEMS
b. Turn on “SHOW VERTICAL SCROLL BAR.”
c. Turn on “ALLOW DELETION OF PORTAL RECORDS.”
Click OK.

Question 2

2. Which window appears after you click OK when having made the choices in the PORTAL SET UP dialog box?

Answer 2

The ADD FIELDS TO PORTAL window.

Question 3

3. What fields do you add to the PORTAL?

Answer 3

DESCRIPTION
PRICE EACH
QUANTITY
EXTENDED PRICE
Then click OK to click out of the window.

Question 4

4. How many ways are there to set the SORT ORDER for a PORTAL? Keep in mind that a PORTAL works through a RELATIONSHIP.

Answer 4

a. You can set the SORT ORDER in the EDIT RELATIONSHIP dialog box (double click on the RELATIONSHIP LINE in the RELATIONSHIP GRAPH)
b. You can also set the SORT ORDER when creating the PORTAL.

Question 5

5. what is the behavior of the SORT ORDER when you set it in the EDIT RELATIONSHIP dialog box?

Answer 5

This SORT ORDER applies to the RELATIONSHIP ITSELF. ANYTIME YOU USE THAT RELATIONSHIP, THE SORT ORDER APPLIES: in PORTALS in ANY LAYOUT, when showing a SINGLE RELATED FIELD, and when FINDING A SET OF RELATED RECORDS.

Question 6

6. What is the behavior of the SORT ORDER when you set it in the PORTAL SET UP dialog box?

Answer 6

IT APPLIES ONLY TO THE PORTAL ITSELF.

Question 7

7. What if you DON’T set a SORT ORDER in the PORTAL SET UP dialog box?

Answer 7

FileMaker uses the RELATIONSHIP’S SORT ORDER, if any.

Question 8

8. If you know that every time you look at your RELATED DATA it SHOULD BE SHOWN IN A SPECIFIC ORDER, then set the SORT ORDER by the:

Answer 8

RELATIONSHIP.

Question 9

9. If you think the RELATED DATA should be SORTED DIFFERENT WAYS IN DIFFERENT CONTEXTS (and thus in different PORTALS), then the SORT ORDER should be set by:

Answer 9

The PORTAL SET UP dialog box. When you’re planning on VIEWING DATA IN LOTS OF DIFFERENT ORDERS, rely in SORTED PORTALS instead of SORTED RELATIONSHIPS.