เปิดบริการตั้งแต่ 29 มกราคม 2550 - ปัจจุบัน
| เปิดบริการมาแล้ว 18 ปี 0 เดือน 20 วัน
single page jaa

Create -modify or delete a relationship Availability 2007

Create -modify or delete a relationship Availability 2007

Once you’ve created a dining table for each subject in your databases, you should promote Office Supply 2007 to the manner in which to bring you to definitely recommendations back together with her once more if needed. You will do it because of the position popular sphere inside tables that are relevant, and by identifying desk relationships amongst the dining tables. Then you can manage questions, variations, https://sugardaddydates.net/sugar-daddies-usa/ca/san-francisco/ and you can account you to display suggestions off numerous dining tables at a time.

Manage a desk matchmaking

You possibly can make a table relationship regarding Dating windows, or from the hauling an area to a great datasheet regarding the Profession Number pane. After you perform a love anywhere between tables, an average sphere aren’t required to have the same brands, although it is usually the situation that they manage. As an alternative, the typical fields need to have an identical investigation form of. When your number one secret profession try a keen AutoNumber field, not, the newest foreign key career can also be a variety career in the event that the new FieldSize possessions regarding each other sphere is similar. Such as for instance, you could potentially meets an enthusiastic AutoNumber community and a variety community if the brand new FieldSize possessions out of each other fields was Long Integer. Whenever each other common sphere try Matter fields, they need to have the same FieldSize possessions setting.

Perform a table relationships utilizing the Dating document case

  1. Click the Microsoft Work environment Button , and click Discover.
  2. In the great outdoors dialogue field, get a hold of and open the fresh databases.
  3. Into the Database Products case, regarding the Reveal/Cover up category, click Relationship.
  4. When you yourself have not yet discussed any relationships, the brand new Tell you Desk dialogue container automatically seems. In the event it doesn’t are available, to your Framework loss, regarding the Dating category, mouse click Reveal Table. The new Tell you Dining table dialogue box screens all dining tables and you can questions from the databases. To see merely tables, simply click Dining tables. To see only inquiries, mouse click Requests. To see both, click Each other.
  5. Choose one or higher dining tables or question and click Include. Once you’ve accomplished including tables and you may questions to your Relationships document loss, mouse click Intimate.
  6. Pull an area (typically the first secret) from dining table with the preferred career (the fresh foreign trick) regarding the almost every other table. So you’re able to drag multiple sphere, drive the fresh CTRL trick, simply click per occupation, right after which pull her or him. The fresh new Revise Dating dialogue package looks.
  7. Check if the field brands shown will be common industries having the partnership. If the an industry name’s wrong, click the profession identity and select the correct community away from record. So you can impose referential stability for it relationships, select the Impose Referential Integrity examine box.
  8. Mouse click Do. Access brings a romance line between them dining tables. For folks who chose the latest Demand Referential Ethics consider package, the range appears more substantial at each and every avoid. In addition, once again only when you chose brand new Demand Referential Integrity see field, the amount step one seems along the dense section on one side of relationship line, in addition to infinity icon (?) looks along the heavy part towards on the other hand of your own line, given that revealed on the following contour.

Leave a Reply

Your email address will not be published. Required fields are marked *