Select the paired criteria from the list in the middle part of the dialog box and click Duplicate or Delete.Īdd a related record (to the related table) whenever you enter data into a related field in a record of the current table Select a new relational operator from the list and click Change.ĭuplicate or delete a pair of join criteria Select a new match field and click Change or Add. To change settings for a relationship, double-click the indicator line between the related tables. Repeat step 3 for each match field in this relationship. Rename the new table occurrence, or click OK to accept the default name. Note For self-joining relationships, drag a match field in the current table outside the table and then back onto the second match field within the current table. You can also click and specify the relationship. Note You can’t change tables within a relationship you must create a new relationship.ĭrag from a match field in one table to the corresponding match field in the other table. To rename a duplicated table, click and type the new name. To duplicate a table in the relationships graph, select the table and click. See Adding and selecting table occurrences. To add a table to the relationships graph, click. For self-joining relationships, locate the single table FileMaker Pro will create the second table occurrence for you. They can appear anywhere on the graph, but they must be present on the graph in order to create the relationship. In the relationships graph, locate the two tables you will be using for this relationship. Choose File menu > Manage > Database, then click the Relationships tab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |