Why create dining table dating?

You possibly can make dining table dating explicitly by using the Dating windows, or by the dragging a field in the Job Listing pane. There are reasons why you should carry out desk relationship prior to you create other databases things, instance forms, issues and you can account.

To utilize records regarding one or more dining table, you often need perform a query you to definitely matches brand new tables. Brand new inquire works by coordinating the costs however key world of the original table with a different trick job during the the following desk. Such, to return rows one identify all of one’s purchases for each and every consumer, you build an inquiry one touches the clients dining table towards Requests dining table based on the Customer ID community. Regarding Dating screen, you could yourself identify the new fields to join. However,, if you actually have a relationship outlined [...]