Database Reference
In-Depth Information
Let's adjust the width of a couple of columns to accommodate their longest entries.
3
In the row of field names at the top of the table, point to the right border of the
Product Name
column, and when the pointer changes to a double-headed arrow,
double-click the border.
4
Double-click the right border of the
Category
column to adjust that field's width.
Notice that the products
Magic Lily
and
Autumn Crocus
are assigned to the
Bulbs
category.
TIP
You can also resize a table column by pointing to the border and dragging it to
the left or right.
Now let's open a second table.
5
In the
Navigation
pane, click the
Shutter Bar Open
button, and then double-click
Categories
to open the
Categories
table on a new tabbed page in
Datasheet
view.
Notice that the
Products
table is still open and available if you need it.
TIP
From now on, open the Navigation pane whenever you need to work with a dif-
ferent object, but feel free to close it if you want to display more of the data.
6
In the
Categories
table, at the left end of the record for the
Bulbs
category, click the
Expand
button (the plus sign) to display a subdatasheet containing all the records
from the
Products
table that are assigned to the
Bulbs
category.
You can display records from two related tables simultaneously.