Database Reference
In-Depth Information
Clicking the ID field for a record in the Rep datasheet form opens a pop-up form with details for that rep,
as shown in Figure E-5.
Pop-up form
displays data for
the selected rep
372
Selected
rep record
FIGURE E-5
Pop-up form for rep with ID 2
Clicking the Customer-Rep Query tab displays the query results, as shown in Figure E-6, in a datasheet
form. The Customer-Rep query joins the Customer and Rep tables, and displays the CustomerNum,
CustomerName, and RepNum fields from the Customer table and the FirstName and LastName fields from
the Rep table. These tables are related using the RepNum field. In a Web database, however, you do not
create relationships as you do in a regular database. Instead, you create the relationships using lookup
fields. Thus, as you add the fields to the tables in a Web database, you must also create the required lookup
fields to relate the tables. You
'
ll learn how to relate tables in a Web database later in this appendix.
Query results
displayed in a
datasheet form
FIGURE E-6
Customer-Rep Query tab selected
