Creating Relationships among Tables

Q

In my MS Access 2000 database, I have 4 tables: Bank, Client, Account, and Transaction. How to build relationships among those tables?

✍: FYIcenter.com

A

This tutorial shows you how to create 3 relationships:

Bank.id = Account.bank_id – Linking an account to a Bank record.
Client.id = Account.client_id – Linking an account to a Client record.
Account.id = Transaction.account_id – Linking a transaction to an Account record.

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

MS Access Creating Relationships

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💬

Using Multiple Selections in Form Design
In MS Access form design, can I select multiple fields and modify their properties simultaneously? Yes. You can. This tutorial shows you how to use multiple selection in Form Design to modify the Text Align property of all field labels in MS Access 2000. Usually, the standard form created by the for... 2010-04-10, 13774👍, 0💬

Using Combo Box with Table Rows in Form
I have a field in a MS Access form that is a foreign key pointing to another table. Can I use a combo box for this field? Yes. You can. This tutorial shows you how to add a combo box with rows from a reference table and bind it to a column in the supporting table in MS Access 2000. Another problem i... 2010-04-10, 12747👍, 0💬

add on for Internet Explorer
Every time I open Internet Explorer a bar pops up saying that it is runner with out add ons. I check to see if all is enabled, which it is. How can I fix this? 2010-04-20, 12666👍, 0💬

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? This tutorial shows you how to create 3 relationships: Bank.id = Account.bank_id – Linking an account to a Bank record. Client.id = Account.client_id – Linking an ac... 2014-12-31, 11270👍, 1💬

💬 2014-12-31 mac: didn't really explain the relationship reasoning at all. I'm not sure there is an easy answer by the way, took me years to truly...

Generating a Standard Report
I have a table with many record in a MS Access table. How do I create a report to list all records in the table? Assuming that you have a table called Transaction in MS Access 2000 with these fields: id - AutoNumber: The primary key giving an unique ID for each transaction. trans_date – Date/Time: T... 2010-04-10, 10101👍, 0💬

Using Combo Box with a Value List in Form
I have a field in a MS Access form that takes only two possible values. Can I use a combo box for this field? Yes. You can. This tutorial shows you how to add a combo box with a value list and bind it to a column in the supporting table in MS Access 2000. In the standard Account Form created by the ... 2010-04-10, 9571👍, 0💬

How to clear up the Desktop?
How to clear up the Desktop? The PC fix: Stash files and apps under My documents. For desktop access to certain items, create shortcuts, tiny files that point to real file: Right-click the item and select Send to Desktop. The Mac fix: Move files to folders under Places. to create a shortcut, control... 2010-04-27, 9397👍, 0💬

How to manage Launches ?
How to manage Launches ? The PC fix: In Windows Vista and 7, type "msconfig" in the Start menu; in XP, type "Run", then "msconfig". Click Startup, and deselect apps you don't need right when you turn on the computer. The Mac fix: Go to System Preferences > Accounts, pick your user, and click Login I... 2010-04-20, 8590👍, 0💬

Getting #Name? In a Form Field
Why am I getting “#Name?” in a form field? If you open a form and see “#Name?” in a form field, it means that the Control Source of this field is linked to a non-existing column on the underlying table. The main reason is that you probably modified the underlying table structure by renaming or dele... 2010-04-10, 7834👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.