FIX: Edit Find Not Working in BROWSE After One-to-Many Row

2.50    | 2.50

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, version 2.5
• Microsoft FoxPro for Windows, version 2.5

SYMPTOMS

The Find and Find Again commands on the Edit menu don't work properly in the Browse window of a one-to-many database relationship after they encounter a parent record that has more than one child record.

STATUS

Microsoft has confirmed this to be a problem in FoxPro 2.5 for MS-DOS and FoxPro 2.5 for Windows. This problem was corrected in FoxPro 2.5a for MS-DOS and FoxPro 2.5a for Windows.

MORE INFORMATION

For each record from the parent database that FoxPro displays in the Browse window, all related records (if any) from the child database are displayed. The parent record is displayed once along with the first matching record from the child database. Any subsequent matching records are displayed in the rows following the parent record and the first matching child record. In FoxPro for MS-DOS, shaded blocks are displayed in any columns containing information from the parent database beyond the first matching record. In FoxPro for Windows, the fill character (usually a diamond symbol) for repeated parent information depends on the current Browse window font.

Steps to Reproduce Problem

1. Assuming FoxPro is installed in a directory named FOXPROW on drive C, issue the following code:

         SET DEFAULT TO C:\FOXPROW\TUTORIAL
         SELECT 1
         USE customer.dbf
         SELECT 2
         USE invoices.dbf
         SET ORDER TO TAG cno OF invoices.cdx
         SELECT 1
         SET RELATION TO cno INTO Invoices ADDITIVE
         SET SKIP TO Invoices
         BROWSE FIELDS customer.company, customer.cno, invoices.ino
   

2. From the Edit menu, choose Find.

3. In the Look For box, type "computer" (without the quotation marks).

4. Under Options, select Ignore Case.

5. Choose OK.

6. From the Edit menu, choose Find Again. Repeat this step until you encounter a parent record that has more than one child record.

7. From the Edit menu, choose Find Again.