PRB: You Have Multiple Related Tables. Adding Records Is...

ID: Q118575

The information in this article applies to:

Microsoft FoxPro for Windows, versions 2.6
Microsoft FoxPro for MS-DOS, versions 2.6
Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

If you use the Screen Wizard to create a screen based on two or more related tables, the following WAIT window message will be displayed when you run the screen:

   You have multiple related tables. Adding records is not allowed.

In addition, the Add button in the control box will be disabled.

CAUSE

A screen created by the Screen Wizard automatically checks for multiple and related tables in the Setup code of the screen.

RESOLUTION

By modifying the following command lines in the Setup code of the screen created by the Screen Wizard, you can prevent the message from displaying and also enable the Add push button in the control box:

1. Change

      m.isadding = .F.

   to:

      m.isadding = .T.     && change to .T. (true)

2. Change (this is the second occurrence of the m.is2table variable in the

   Setup code)

      m.is2table = .T.

   to:

      m.is2table = .F.     && change to .F. (false)

3. Comment out these lines as shown:

      * WAIT WINDOW C_MULTITABLE TIMEOUT 1

      * SET SKIP TO  && The SET SKIP TO command exists only if the
      *                 relationship is a one-to-many relationship.

NOTE: Remember that you must regenerate the screen (.SPR) file to see the results of this modification to the Setup code.

Keywords          : kbcode kbtool kbVFp FoxDos FoxWin FxtoolWizscreen 
Version           : 2.6 2.6a
Platform          : MACINTOSH MS-DOS WINDOWS
Issue type        : kbprb