Special Edition Using Access 97, Second Edition

Creating a Transaction-Processing Form with the Form Wizard

The form that you create in this example is typical of the transaction-processing forms used to add new records to the many side of a one-to-many relationship. Adding line items to an invoice is an example of when a form of this kind—called a one-to-many form—is necessary. The object of the Personnel Actions form is to add new records to the Personnel Actions table or allow you to edit the existing records. If you didn't add the Personnel Actions table shown in Figure 12.3 to the Northwind Traders database in Chapter 4, "Working with Access Databases and Tables," or Chapter 5, "Entering, Editing, and Validating Data in Tables," do so before proceeding with this example. The structure ...