Part I Review (Relationships Between Tables)Ī relationship has been created between the “T_Schools” table and the “T_Training” table so that the school address, city_state, and zip can appear on any layout associated with the “T_Training” table – matching “School” to “School.”Ī relationship has also been created between the “T_Classes” table and the “T_Training” table so that the class name, dates, location, and other related information can appear on any layout associated with the “T_Training” table by matching “Class_Code” to “Class_Code.”Īll relationships are bidirectional: draw it once, and it applies both ways to both tables. Lesson 15: Use Instant Web Publishing to allow the sharing of a database with users in a Web browser allowing them to find, browse, and/or modify data.
Lesson 14: Create and assign Accounts and Privileges to allow database administrators to manage accounts and assign appropriate levels of access to records, layouts, value lists, and scripts. Lesson 13: Create a special display called a portal, in which data will be shown from fields in related tables. File Options - Switch to Layout/Perform Script 44-45.Creating a Button to Execute a Script.Navigating to Specified Layouts using Buttons.Creating a Main Menu with Navigation Buttons 39.Automate tasks for opening and closing a file. Lesson 12: Create a new layout to allow a one-click navigation to other layouts and scripts. Build a report that summarizes and sorts data on a field and show sub-totals from a related field. Lesson 11: Create individualized form letters by merging fields from related tables. Boolean Find (Finding Multiple Requests).Lesson 10: Learn different methods for finding records, such as finding data in one field (simple find), multiple fields (Boolean Find), and excluding (omitting) records. Creating a Horizontal Dividing Line Between Groups of Layouts.Use Toolbars to provide quick access to many FileMaker Pro menu commands. Lesson 9: Create a new layout for labels and learn how to add visual enhancements to existing layouts, such as dividing lines and grouping similar layouts. Entering New Records / Modifying Records.Learn tips and techniques for adding and modifying records to speed data entry. Lesson 8: Review relationships between Match Fields in different tables.
0 kommentar(er)
