Many-to-One
Forms (Cont'd)
Here is a form, dressed up a little, based on the previous query.
Empno and wono are the composite primary key of the labor ticket.
They are also foreign keys to the primary keys in the employees and
work_orders tables. By selecting an empno or work_order no from the
drop downs, the corresponding information from the employees and
work_order tables is automatically filled in on the form.
This same technique could be used to display shipping and billing
addreses for a customer, etc. Equally the fields could have been
displayed in tabular format like an invoice line-item. This is
illustrated below.
I hope you found this article useful. We may update it to
later versions of Microsoft Access in a future article. Although the concepts
are the same some of the screenshots will be different due
to the Microsoft Office Ribbon. |