This set entered on 5-16-14.
5.5.14.2
- p 349. ADVANCED RELATIONSHIP TECHNIQUES. You create a VALUE LIST from an existing field. In the SPECIFY FIELDS FOR VALUE LIST, you choose the TABLE, then the field and “ALSO DISPLAY VALUES FROM SECOND FIELD.” How should you sort the fields?
On the bottom half you have the option of sorting the values using the first field or the second field.
- If you elect to show a SECOND FIELD in the VALUE LIST (Based on VALUES FROM ANOTHER FIELD), you should only choose a value from the same table as the first value because:
YOU DON’T. You can choose a value for the SECOND FIELD from another table.
- If the SECOND FIELD is NOT from the SAME TABLE as the first field, FileMaker uses:
The VALUE from a RELATED RECORD.
- The SPECIFY FIELDS FOR VALUE LIST offers the option to INCLUDE ONLY RELATED VALUES. What is this?
This causes FileMaker to look ONLY at the RECORDS RELATED TO THE ONE YOU’RE SITTING ON.
- For the INCLUDE ONLY RELATED VALUES option to work, FileMaker has to know:
which TABLE OCCURRENCE you’re coming from. In other words, if you ask only for the RELATED JOBS, do you mean JOBS RELATED TO THE CUSTOMER or to THE INVOICE RECORD?
- When you create a VALUE LIST like this, it works properly only when:
IT IS ATTACHED TO A FIELD ON A LAYOUT ASSOCIATED WITH THE SAME TABLE OCCURRENCE SELECTED IN THIS MENU. If you want to use this VALUE LIST on a DIFFERENT LAYOUT, FileMaker does not know which record to start from and the VALUE LIST WON’T SHOW THE RIGHT VALUES.
