Why do table relationship?
You possibly can make desk relationship clearly utilizing the Dating screen, otherwise by the hauling an industry throughout the Profession Record pane. There are numerous reasons to carry out desk relationships before you make almost every other databases things, particularly forms, inquiries and you can account.
To utilize suggestions away from several desk, you commonly have to create an inquiry that suits the brand new dining tables. The fresh new ask works by coordinating the prices in the main key world of the first desk having a foreign trick industry in the second dining table. Such, to go back rows you to identify all of orders per customers, your create an inquiry you to definitely matches the purchasers desk to the Commands table in line with the Customers ID profession. (more…)