Microsoft KB Archive/118575

{| = PRB: You Have Multiple Related Tables. Adding Records Is... =
 * width="100%"|

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
 * }