User manual LEGRAND 843 77

[. . . ] Credits are listed in the Acknowledgements document provided with this software. Mention of third-party products is for informational purposes only and constitutes neither an endorsement nor a recommendation. assumes no responsibility with regard to the performance of these products. Edition: 01 Contents Lesson 1 FileMaker Pro basics How to use this tutorial Where to find the sample file Database concepts What is a database? [. . . ] Press Enter (Windows) or Return (Mac OS) twice to create two line spaces at the end of the address. 2. Insert merge fields for the first and last name, separated by a space. In your own letters, you can use more fields (for example, a title field) for a more elegant salutation. 4. Type the letter: The Corporate Travelers Club welcomes you and your company to our organization. The Text tool is selected We look forward to doing business with you and hope you have many pleasant trips with us!To turn off this special underlining in this file, choose File menu > File Options. Clear Indicate questionable words with special underline. Add the address 1. Move to the next line (enter a line space): Clear this checkbox to turn off underlining of misspelled words 1 Windows: Press the Enter key above the Shift key on the keyboard. Add merge fields for the street address, city, and country, with appropriate spaces, new lines, and punctuation. If a field is likely to contain words (such as names) that a spelling checker will mark as misspelled, you can turn off spelling checking on specific fields. Lesson 6 | Creating lists, mailing labels, and form letters 35 Customize the letter with the company name 1. Type another comma. For more information In this lesson, you have created list, label, and form-letter layouts. You can create as many layouts as you like, to organize your information in any way you like. To learn how to create other layouts, see lesson 9 in this tutorial and chapter 3 in the FileMaker Pro User's Guide. For information about turing off spelling checking in specific fields in a file, see FileMaker Pro Help. Add the closing 1. Click OK. If you receive an error message, make sure that all spaces and punctuation are identical to the formula shown above. 14. Click OK to close the Manage Database dialog box. The Renewal Fee field appears at the bottom of the layout, below the Membership info tab panel. Depending on the size of your screen, you may need to scroll down to see it. 15. Select the Renewal Fee field and its label and drag them under the Member Since field. Notice that the format of the Renewal Fee label does not match the format of other labels in the sample database. Select 12 for Size and Plain for Style, and dark gray for color. Verify the type of data to be returned by the calculation Replace these placeholders with your calculation 20. Select the placeholder test and type: Membership Type = "Continuing" exactly as it appears here. 10. Make sure the calculation result is set to Number. Your calculation formula is now complete. When data is entered in the Membership Type field, FileMaker Pro will compare it to the word we are testing for, "Continuing. " The test is true if it matches this word, and the calculation will return your first result, 100. If it doesn't match, the test is false, and the second result is returned. Test your calculation To see if your calculation works, switch to Browse mode and try changing the value in the Membership Type field to Continuing. Notice the result in the Renewal Fee field--it changes as the membership type changes. 40 FileMaker Pro Tutorial Automatically enter a serial number FileMaker Pro lets you automatically enter certain types of data--for example, incremental numbers--when you create a new record. 11. [. . . ] For Description, type Customer Service Agent. Predefined privilege sets Each new database file has three predefined privilege sets. 1 Full Access permits accessing and changing anything in the file 1 1 Specify settings for this account Data Entry Only permits only the viewing and entering of data Read-Only Access permits viewing but not changing data In every database, there must be at least one account with the Full Access privilege set. You can't change or delete predefined privilege sets except to enable or disable their extended privilege sets, but you can duplicate predefined privilege sets and modify the copy to use it in a different way. 12. Click OK. You see the new account listed with the default Guest and Admin accounts. 13. [. . . ]