![]() A team member can work on multiple projects, so a many-to-many relationship makes sense here. When you add a child record to the parent record form, Tap Forms will switch the display to the child form (in this case Client Expenses) along with a back button which when clicked will return you to the parent record from where you came.Īn example of a Many to Many link could be a list of team members who are assigned to projects for the selected Client. By adding a record from this view Tap Forms will link the new Client Expense record to the parent Client record. Initially there will be none, but you can click the + button above the list of Client Expense records to add one. Now when you add or edit a record on your Client form, you can see the list of Client Expenses. Tap Forms will create it and set it up properly for you when you enable the Show Inverse Relationship option. !Don’t create your own Link From Form field. ![]() In our example that means a Client Expense record will display a field that links back to the Client form so for any selected Client Expense record, you’ll easily be able to see which Client it belongs to. Enabling the Show Inverse Relationship option will automatically create a Link From Form field which will show you which parent record linked to the record you’re viewing. You can enable the Show Inverse Relationship option if you would like Tap Forms to manage both sides of the relationship for you. *A note about the Show Inverse Relationship option. Make sure you’ve selected One to Many as the Link Type. ![]() Create a Client Expenses form:Ĭreate a Clients form and link it to the above Client Expenses form: One client has many unique expenses which are attributable only to it. A one to many relationship is useful in this situation. If you wanted to keep track of all the expenses you incur when working for a specific client, you wouldn’t want those expenses to be linked to any other client than the one for whom you are currently working. It’s easiest to describe this situation using an example. That is, no two parent records should link to the exact same records from the child form. The One to Many link type is useful in situations where the child form’s data is unique to the parent record it’s linked to. Any form that the main form links to will be called the child form. To make it easier to identify what is being talked about in this section of the documentation, I’ll refer to the main form as the parent form. There are currently three types of links: Tap Forms has the ability to link forms together to establish relationships between them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |