I have an 8 tab form used for editing data. On 6 of these tabs I have a dbgrid. For the tabs with a dbgrid, If I use a dbnavigator arrow or click on succeeding rows the response time is much slower than if these tabs were standalone forms. The command I use to start this form is; EDIT USING Book2 + TABLE=BOOKS PRIMARY KEY FIELD=DEALNO ARRANGE other BY dealno, + TABLE=OTHER FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO ARRANGE advances BY AdvRdate desc, + TABLE=ADVANCES FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO ARRANGE paydeal BY PDpayshare, + TABLE=PAYDEAL FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO ARRANGE rledger BY dealno,RLtrandate desc, + TABLE=RLEDGER FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO ARRANGE clroyalties BY dealno, + TABLE=CLROYALTIES FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO ARRANGE clsubrights BY dealno,SRRSdesc, + TABLE=CLSUBRIGHTS FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO ARRANGE royrec BY dealno,rrtrandate desc,rrroyalty + TABLE=ROYREC FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO whe cno=.vcno and dealno=.vdealno
I confirmed that all of the tables have different column names except for the primary and foreign key. I am using the latest 7.6 update 7.6.4.30728. Can anyone point me in a direction where I can speed things up in these dbgrids ? Thanks in advance. Bill Eyring
