Filemaker Pro 9 (85)

Question 1

This set entered on 5.25.14
5.22.14.8

1. The ADVANCED THECHNIQUE from the previous card set is just like:

Answer 1

searching for RECORDS, without all the hassle of going to FIND MODE and actually performing a search.

Question 2

2. What are the steps for the ADVANCED TECHNIQUE of USING A GLOBAL POP UP FIELD TO CHANGE THE DISPLAY IN A VALUE LIST?

Answer 2

First, you need to make the LINE ITEM ID field into a pop up menu.

Question 3

3. The following are the steps for this ADVANCED TECHNIQUE. Double click the LINE ITEM ID field, and choose POP UP menu from:

Answer 3

the DISPLAY AS pop up menu. The DISPLAY VALUES FROM pop up menu appears, with displayed.

Question 4

4. from the DISPLAY VALUES FROM pop up menu, choose:

Answer 4

MANAGE VALUE LISTS. You need a new value list based on the values in the LINE ITEM ID field from the Assign Expenses__Invoices__LINE ITEMS TO.

Question 5

5. Click NEW and type INVOICE LINE ITEMS as the VALUE LIST NAME.

Answer 5

Even though you’re about to ASSIGN your new VALUE LIST TO A FIELD, you want the name to be descriptive so you can remember your thought process later on.

Question 6

6. Turn on the USE VALUES FROM FIELD Radio Button so that:

Answer 6

that FIELD’S DATA shows up in your new VALUE LIST.

Question 7

7. Choose Assign Expenses__Invoices__LINE ITEMS form the SPECIFY FIELDS Window’s drop down list. Then:

Answer 7

click the LINE ITEM ID field. Select “INCLUDE ONLY RELATED VALUES STARTING FROM” and, from the DROP DOWN LIST, choose Assign Expenses__EXPENSES.

Question 8

8. The process on card #7 will:

Answer 8

keep users form assigning an EXPENSE to a LINE ITEM from the WRONG INVOICE, or from ASSIGNING AN INVALID LINE ITEM ID.

Question 9

9. The option from card #7 tell item VALUE LIST to DISPLAY ONLY:

Answer 9

LINE ITEMS that are related to the INVOICE that matches the value in your Global Invoice ID field.

Question 10

10. Since the Global Invoice ID field is on the Assign Expenses__EXPENSES TO, that’s:

Answer 10

where the VALUE LIST RELATIONSHIP is “STARTING FROM.”

Question 11

11. Turn on the “ALSO DISPLAY VALUES FROM SECOND FIELD” checkbox, and form the list, choose:

Answer 11

the DESCRIPTION FIELD. Since a LINE ITEM ID isn’t very meaningful by itself, you want to show the description too.

Question 12

12. Turn on the SORT BY SECOND FIELD radio button and click ok until all the dialog boxes are gone. You’re back on:

Answer 12

your ATTACH LINE ITEMS LAYOUT and your LINE ITEM ID field is formatted with your new value list.

Question 13

13. Switch to BROWSE MODE and use the new layout. If you type 1 in the Global Invoice ID field, you should be able to:

Answer 13

pick a LINE ITEM from the pop up menu

Question 14

14. When you pick a LINE ITEM from the pop up menu, the ASSIGN EXPENSES: EXPENSE LINE ITEM::DESCRIPTION field should:

Answer 14

show the selected line item’s description.