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

• 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.

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.