Microsoft KB Archive/96190

= Using Multiple Proposed Responses in the Database =

Article ID: 96190

Article Last Modified on 11/24/2003

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Windows 3.0 Standard Edition
 * Microsoft Windows 3.1 Standard Edition

-



This article was previously published under Q96190



SUMMARY
By entering a formula in the Works Database module, you can create a proposed response--a default value for that field. This technique is often used with fields in which the information usually remains the same, such as the City, State, or ZIP Code field. If you need two or more proposed responses, such as two city names, the Copy and Paste commands can be used in conjunction with default value formulas, as in the following example.



MORE INFORMATION
Suppose that, in the City field, 50 percent of your records need &quot;Amsterdam&quot; and the other 50 percent need &quot;Hoofddorp.&quot; Using the following method, you can insert both city names using formulas:


 * 1) Insert the formula =&quot;Amsterdam in the City field.
 * 2) Select the records that must contain &quot;Amsterdam&quot;, using, for example, a query.
 * 3) Select those cells in the City field that are to remain &quot;Amsterdam&quot;.
 * 4) From the Edit menu, choose Copy.
 * 5) Without moving the insertion point, choose Paste from the Edit menu.

The default value formula is then converted to text strings for those cells.
 * 1) Insert =&quot;Hoofddorp in a blank record in the City field.

All records that do not already contain text in the City field, such as &quot;Amsterdam&quot;, will have &quot;Hoofddorp.&quot; The records with preexisting text are not affected in any way.

Keywords: KB96190

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.