10 Jun Would -edit otherwise delete a relationship Accessibility 2007
After you've created a dining table for every topic on the database, you should promote Workplace Supply 2007 on manner in which to bring one information back along with her once more when needed. You will do this of the establishing well-known industries for the dining tables which might be relevant, and also by identifying table matchmaking amongst the dining tables. Then you can would concerns, models, and you may accounts you to definitely screen guidance off numerous tables at the same time.
Perform a desk relationship
You possibly can make a desk matchmaking on the Relationships window, otherwise by dragging an area on to a great datasheet in the Profession Record pane. Once you manage a relationship ranging from dining tables, an average industries aren't needed to have a similar brands, though it is often the case that they do. As an alternative, the average areas need the same research types of. If the primary key community try an AutoNumber job, but not, brand new foreign trick job can also be lots career if the latest FieldSize property out of each other areas is the identical. Instance, you might suits an AutoNumber field and you will a variety career in the event that the newest FieldSize property out of both sphere are Long Integer. Whenever both preferred sphere are Number fields, they need to have the same FieldSize property function.
Manage a table relationships utilizing the Matchmaking file tab
- Click on the Microsoft Office Option , and then click Discover.