|
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.
 |
