Filemaker Pro 9 (86)

Question 1

This set entered on 5-25-14
5.22.14.

1. p 382. THE SECRET LIFE OF A GTRR. If you’re on the EXPENSES LAYOUT looking at an EXPENSE, and want to assign on INVOICE LINE ITEM to that EXPENSE, you switch to the ATTACH LINE ITEMS TO EXPENSES LAYOUT to do just that, but:

Answer 1

when you switch layouts, you don’t see the same record, BECAUSE EACH TABLE OCCURRENCE has its own CURRENT RECORD, FOUND SET, AND SORT ORDER.

Question 2

2. How do you solve the issue on card #1?

Answer 2

a. Do ANOTHER FIND for the record you had on the previous layout (this is not your best choice) OR b. Use GTRR

Question 3

3. How do you use GTRR so that when you switch from the EXPENSES LAYOUT to the ATTACH LINE ITEMS TO EXPENSES layout, you can jump right into the same record?

Answer 3

GTRR CAN TRANSFER A FOUND SET - complete with current RECORD and SORT ORDER - from one TO to another.

Question 4

4. The GTRR Options window has a GET RELATED RECORD FROM pop up menu that shows:

Answer 4

EVERY TABLE OCCURRENCE in the DATABASE.

Question 5

5. When you select an OCCURRENCE from the GET RELATED RECORD FROM pop up menu, you get a list of layouts to switch to, but this is NOT restricted to:

Answer 5

Layouts ATTACHED to the SELECTED TO. IT SHOWS LAYOUTS ATTACHED TO ANY OCCURRENCE OF THE SAME TABLE.

Question 6

6. In other words, when you ask to go to a RECORD in the EXPENSES TO, you can:

Answer 6

pick the ATTACH LINE ITEM TO EXPENSES layout, EVEN THOUGH IT IS ASSOCIATED WITH A DIFFERENT OCCURRENCE OF THE EXPENSES TABLE.

Question 7

7. When you use this technique, FileMaker shows the records DICTATED by the RELATIONSHIP, but:

Answer 7

USES THE LAYOUT YOU CHOOSE.

Question 8

8. To make this GTRR connection, add a button to the EXPENSES layout that runs the GTRR command. When you set up this button, choose:

Answer 8

the EXPENSES TO and the ATTACH LINE ITEM TO EXPENSES layout.

Question 9

9. When you create the button with the GTRR, make sure you turn on:

Answer 9

SHOW RELATED RECORDS ONLY

Question 10

10. You can also add a button to the ATTACH LINE ITEM layout that transports you BACK to the EXPENSES layout. This time you CONFIGURE the GTRR command to:

Answer 10

use the Assign Expenses__EXPENSES Table Occurrence and the EXPENSES layout