Specifications

Contents
xiv
InfoMaker
Master/Detail One-To-Many forms........................................ 511
Master/Detail Many-To-One forms........................................ 513
Creating and saving forms ........................................................... 514
Creating basic forms ............................................................. 514
Creating a master/detail form................................................ 516
Defining data so that a form can update a database............. 520
Generating and saving forms ................................................ 521
Working with forms....................................................................... 523
Running forms....................................................................... 523
Limiting the retrieved data..................................................... 524
Importing data into a form ..................................................... 525
Saving data in an external file ............................................... 526
Printing forms ........................................................................ 527
Actions in forms..................................................................... 527
Accessing and deleting forms ............................................... 530
CHAPTER 19 Controlling Updates in Forms .................................................... 531
About controlling updates............................................................. 531
What you can do ................................................................... 532
Specifying the table to update...................................................... 533
Specifying the unique key columns.............................................. 533
Specifying an identity column....................................................... 534
Specifying updatable columns ..................................................... 534
Specifying the WHERE clause for update/delete......................... 535
Specifying update when key is modified ...................................... 537
CHAPTER 20 Enhancing Forms ........................................................................ 539
About enhancing forms ................................................................ 539
Working in the Form painter Layout view..................................... 540
Using the Form painter toolbars............................................ 540
Using the pop-up menus in the Form painter........................ 542
Using the Properties view in the Form painter ...................... 542
Selecting controls in the Form painter................................... 543
Defining default colors and borders in the Form painter ....... 544
Printing the form definition..................................................... 546
Reorganizing controls in the form ................................................ 546
Using the grid in the Form painter......................................... 546
Deleting controls in the Form painter .................................... 547
Moving controls in the Form painter...................................... 547
Copying and pasting controls in the Form painter................. 548
Resizing controls in the Form painter.................................... 549
Aligning controls in the Form painter..................................... 549
Equalizing the space between controls in the Form painter.. 550