Microsoft KB Archive/64127

Works: Creating Multiple Fields with Same Name in Database

PSS ID Number: Q64127 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbotherunique

= SUMMARY =

You cannot create fields with the same name in the Works Database. A workaround exists that allows the creation of multiple fields with the same name in Form view only.

To create multiple fields with the same name, do the following:


 * 1) Enter all the fields in Form view using different field names for each field, followed by a colon.
 * 2) Hide all the field names that will have the same name. Position the cursor on the area next to the field name to be hidden (note: do not put the cursor on the actual field name), select Format Show Field Name and press ENTER (ALT, T, N). This procedure will cause the field name to disappear.
 * 3) Now, position the cursor where the field name was, type a new name without a colon “:”, and press Enter. Immediately press F2 and type the colon “:”.
 * 4) Repeat Step 3 for all fields that need the same name.

The fields will have different names in List view; however, it will appear as though the fields all have the same name in Form view.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.