A few months ago were there changes to the database? The hosting machine? FMP version?
Do you have a known good backup from before the problem occurred?
A corrupt index might cause the problem.
Without some understanding of the database design--what tables, relationships, portals, etc where created and how they are set up, it's impossible to offer specific help with you issue as there could be many different causes.