Filemaker Pro 9 (69)

Question 1

This set entered on 5-17-14
5.6.14.2

1. p. 358 NAVIGATING BETWEEN RELATED RECORDS. What is GTRR?

Answer 1

Go To Related Record

Question 2

2. What does GTRR do?

Answer 2

It is a BUTTON COMMAND that goes to a RELATED RECORD. Say you have an INVOICE with a CUSTOMER’S NAME linked to it. Make the CUSTOMER’S NAME in the INVOICE a button with GTRR and it will take you to the CUSTOMER in the CUSTOMER’S LAYOUT.

Question 3

3. GTRR can ALSO find all the RELATED RECORDS and then SORT THEM if:

Answer 3

the relationship you’re using has a SORT SPECIFIED.

Question 4

4. What are all the uses of GTRR?

Answer 4

a. Go to a RELATED RECORD
b. Find all the RELATED RECORDS and SORT THEM (if the RELATIONSHIP has a SORT SPECIFIED)
c. It can CREATE A NEW WINDOW d. Lets you set an OPTION that includes the use of a FOUND SET.

Question 5

5. How do you turn a Customer’s Name into a GTRR BUTTON?

Answer 5

Select CUSTOMER'S NAME in the layout, choose 
FORMAT-->
BUTTON SETUP, 
choose the 
GO TO RELATED RECORD script command.

Question 6

6. What happens when you choose the GO TO RELATED RECORD script command?

Answer 6

The GO TO RELATED RECORDS options Dialog box pops up.

Question 7

7. What are the OPTIONS in the GTRR Options dialog box?

Answer 7

GET RELATED RECORDS FROM

SHOW RECORD USING LAYOUT

SHOW IN NEW WINDOW

SHOW ONLY RELATED RECORDS.

Question 8

8. From the GET RELATED RECORD FROM pop up menu, choose the CUSTOMER’S table. When you pick a TABLE OCCURRENCE, you determine which table the button goes to. NOTICE THAT FILEMAKER SHOWS YOU ONLY:

Answer 8

the layouts that USE THE TABLE OCCURRENCE YOU JUST SELECTED.

Question 9

9. From the SHOW RECORD USING LAYOUT pop up menu, choose CUSTOMERS. If you’re going to a RELATED RECORD, it is usually from a RELATED TABLE OCCURRENCE:

Answer 9

your CURRENT LAYOUT CAN’T SHOW YOU RELATED DATA, because it DOES NOT HAVE THE REQUIRED FIELDS. So you tell the button which layout to use.