Collections:
Other Resources:
Creating Relationships among Tables
In my MS Access 2000 database, I have 4 tables: Bank, Client, Account, and Transaction. How to build relationships among those tables?
✍: FYIcenter.com
This tutorial shows you how to create 3 relationships:
1. Click the relationships icon in the icon bar. The relationships window opens up.
2. Right click on the window and select the “Show All” command. All 4 tables show up.
3. Double click on the relationships window. The Edit Relationships dialog box shows up.
4. Click the “Create New” button. The Create New dialog box shows up.
5. Enter these values and click OK to close the dialog box:
Left Table Name: Client Left Column Name: id Right Table Name: Account Right Column Name: client_id
5. Click the “Create” button on the Edit Relationships dialog box. The first relationship is created.
6. Repeat these steps to create other 2 relationships.
2014-12-31, 11651🔥, 1💬
Popular Posts:
What is NicConfigSvc.exe process - Internal Network Card Power Management Service? Process nicconfig...
What are wbxtra_*.wbt Temporary Files on my Windows 7 computer? Can I remove them? wbxtra_*.wbt Temp...
What is the file extension .VOB (DVD-Video Object or Versioned Object Base)? .VOB is the file extens...
How to increase the remote login limit on Windows 10? By default, Windows 10 only allows 1 remote lo...
How to add a program into the startup folder? If you find an interesting program that you want to ad...