Database Reference
In-Depth Information
It would improve the process if you could type an Invoice ID
right there on the Expenses
layout
and then see that invoice's Line Item IDs. A new layout called Assign Expenses (
Fig-
ure 14-10
) uses a new set of table occurrences, called a Table Occurrence Group (TOG) to let
you manage line item data from a new Assign Expenses layout.
Figure 14-10. This layout provides a nice interface for assigning line items to an expense. First,
you enter an Invoice ID into a global field. Then the invoice's line items show up in a portal that
shows you the data you need to choose the proper Line Item record to assign to each Expense re-
cord. As before, when you type a Line Item ID, you see the Description, Price Each, Quantity, and
Extended Price that was invoiced for the Expense.
Planning the New Elements You'll Need
The Assign Expenses layout will provide a special set of tools, or an
interface
, to expedite a
certain
process
. In this case, the process is matching line item records to expense records so
you can record the Line Item ID that billed out each expense. For the new interface to work,
you need several new elements. They're listed here to avoid confusion as you start creating
them; you'll learn more about the role each item plays as you build the interface. You need:
▪ A new group of table occurrences that you'll create specifically to handle this task.