You may see this message ('PrimaryKey' is not an index in this table) when you try to view or print either prebills or bills. It indicates that your RTG Bills database is corrupted.

If the only problem is the one stated in the message, that an index is missing, it is easily corrected. There could be other problems in the database, of course. For that reason, you may want to create a backup of your data (File > Backup) and send the two backup files to RTG for analysis.

Follow the instructions in this article:

R070402: Fix Bills or Timer Database

Complete the steps listed there for the Fix RTG Bills Database program. They won't fix this problem, but they may clean up some other problems in the data. Then choose the following menu item:

File > Special > Restore Primary Keys

A warning message appears. Click Yes. Then the program will ask if you want to restore each of several primary keys. In each case, click Yes. Either it will fix the problem if one is found, or it will say the index already exists. In either case, click OK.

Assuming it did restore at least one primary key, your database may now be fixed. Exit from the Fix RTG Bills Database program.

We suggest you look at the following reports to identify any remaining problems:

Verify Matter Balance
Verify Retainer Balance

If those reports show problems, you may have lost data from the database. We suggest you contact RTG and send us the reports in RTG Review format. You may also wish to read a further explanation of those reports: