Yes - still on 5.0a.

I run my application on old data files and there is no problem. Replace old .dbf files with the current ones, and the main form comes up with an outline, title bar, etc., but the inside is transparent and I can see the background.

When I step through it, the form finishes filling in with data. I have validated the database with no errors, I can open the current .dbf files and browse them. When I overwrite the old .dbf files one at a time, the application does fine until I overwrite the quarters.dbf file -- that one seems to be the culprit

I tried a few simple select statements to check the RI from the command window:

use company (co_id primary key has to match the foreign key co_id in quarters)
select * from quarters where co_id not in
(select co_id from company)

Did a similar statement for every foreign key in quarters but did not find any
orphans.

Is there any way to try and check the RI? Any ideas on what is going on? Am I going in the wrong direction?

This is an old standalone before we had networking. The user had a routine to back up the data, but never used it, so 5-month old data is the only dataset that is working.


Thanks,
Carol Adler for Tony Gibson