Categories:
Administration (10)
Adware Spyware (7)
Apache (10)
Bluetooth (125)
DOS Commands (1)
Edge (28)
General (2)
Internet Explorer (217)
Media Center (12)
Media Player (11)
Mozilla Firefox (18)
PHP (15)
Programming (8)
Security (4)
Silverlight (15)
Tips (17)
Tools (218)
Tutorials (5)
Windows 10 (166)
Windows 7 (636)
Windows 8 (1091)
Windows Phone (33)
Windows Server 2008 (165)
Windows Server 2012 (84)
Windows Server 2016 (23)
Windows Vista (52)
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, 11269👍, 1💬
Popular Posts:
How to create a command button to run my macro in slide show view? I have created a macro that displ...
How to get file properties in Windows PowerShell? I want to know when the file was originally create...
How to tell Apache server to transform (rewrite) URL? Assuming that you have your Apache server runn...
How to remove DVDLauncher.exe from the startup application list to gain performance and reduce secur...
What is "WLAN AutoConfig" in my Windows 7 service list? And how is "WLAN AutoConfig" service related...