|
|
|
Creating a Relational Customer and Customer Orders System Using LogiBridge and MS Access
|
|
Page
7 of 8
|
|
|
|
|
Building the Relationship in Microsoft Access
|
Wouldn't it be nice if we could select a customer and have all their order history displayed? By defining a relationship between the customer and the orders table, we can do just that. Once we've defined a relationship between the two, we can easily view the relational data and generate reports where the orders are grouped together with the customer entry.
- Double click the 'Customer' table to open it.
- Select Insert > SubdataSheet. The 'Insert Subdatasheet' window opens.
- Click the Orders tables. We're going to link the two tables together using the 'company' field.
- From the Link Child Fields drop down, select 'company'.
- From the Link Master Fields drop down, also select 'company'.
Figure 13: The Insert subdatasheet window properly configured.
- Click OK, a prompt will appear telling you that Microsoft Access did not detect a relationship between these tables and asking you if you want the relationship to be created now. Click Yes.
- A small plus sign is now shown next to each customer row that has linked data in the orders table. Clicking the plus sign, reveals the data as shown below
Figure 14: Clicking on a Customer now reveals that customers order history.
|
Page
7 of 8
|
|
|
|
|
