This set entered on 5-17-14.
5.6.14.2
- p 360. Do you need a PORTAL to get AUTOMATIC CREATION of RELATED RECORDS?
NO. AUTO CREATION works when you type in ANY RELATED FIELD as long as the RELATIONSHIP IS SET UP TO ALLOW IT.
- How do you activate AUTO CREATION with a ONE TO ONE RELATIONSHIP?
Say you have a ONE TO ONE RELATIONSHIP with one table for BOOK RESOURCES (cover art) and another for BOOK INFORMATION (name, author, etc). Both tables share a BOOK ID field, but only the BOOKS::BOOK ID field is a SERIAL NUMBER. You tell FileMaker to allow creation of related BOOK RESOURCES records.
- Since the relationship in Card #2 is set to AUTO CREATE BOOK INFORMATION RECORDS, you can:
add a new picture of the BOOK’S COVER in the RESOURCE FIELD (in the BOOK table), and then just type a name right in the book field. FILEMAKER CREATES the related record for you.
- If you’re looking at a CUSTOMER RECORD, you can see all the jobs for that CUSTOMER because they’re right there in the JOBS PORTAL. But what if you want to see THOSE JOBS AND ONLY THOSE JOBS IN A SORTED LIST ON THE JOBS LAYOUT?
the easy way is to use the GTRR Command, then you add a few options.
- THE REMAINDER OF THIS CARD SET DEALS WITH SHOWING RECORDS IN A PORTAL IN A SORTED LIST ON THE RECORD’S OWN LAYOUT, using GTRR. How is this done?
LAYOUT: JOBS::JOB NAME field FORMAT–>BUTTON SET UP BUTTON SET UP dialog box, select GTRR
- From the GET RELATED RECORD FROM, choose JOBS. From the SHOW RECORD USING LAYOUT pop up menu, choose JOBS. This gives you a layout that shows you:
meaningful data from the JOBS TABLE. So far this is just like creating a RELATED RECORD BUTTON without a FOUND SET. The next steps make all the difference.
- Turn on SHOW ONLY RELATED RECORDS. By doing this, FileMaker changes:
the FOUND SET, showing JUST THE RELATED RECORDS. You land on the DESIRED RECORD, and you have ALL the other records in the FOUND SET. If the RELATIONSHIP has a SORT ORDER, FILEMAKER SORTS THE FOUND SET TOO.
- You now have a GTRR button IN A PORTAL. Go to BROWSE MODE and click on the SECOND PORTAL RECORD, this takes you to:
the SECOND RECORD IN YOUR FOUND SET, NOT the first one.
- From the SORTED, RELATED, Jobs Layout, click on the CUSTOMER NAME button, and you notice that the PORTAL changes the BUTTON’S CONTEXT. How?
The RECORDS related in a PORTAL are already SET, unlike the single field you made into a BUTTON in the previous tutorial.
- When you click the GTRR button on the JOBS LAYOUT, you expect to see:
only the SINGLE CUSTOMER that’s RELATED TO YOUR JOB.
- When you click the button in the JOBS PORTAL, you get:
a FOUND SET of ONLY the JOB RECORDS that you just saw in the PORTAL.
