Each Field List is a resizable window and can be moved within the
Query Designer. If there are more fields than will show in the Field List window, a scroll bar
enables you to scroll through the fields in the Field List.
After a relationship is created between tables, the join line remains between the two
fields. As you move through a table selecting fields, the line moves relative to the linked
fields. For example, if the scroll box moves down (toward the bottom of the window) in tblContacts,
the join line moves up with the customer number, eventually stopping at the top of the table window.
When you??™re working with many tables, these join lines can become confusing as they cross or
overlap. As you scroll through the table, the line eventually becomes visible, and the field it is
linked to becomes obvious.
Moving a table
Move the Field Lists by grabbing the title bar of a Field List (where the name of the table is) with
the mouse and dragging the Field List to a new location. You may want to move the Field Lists for
a better working view or to clean up a confusing query diagram.
Pages:
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455