I have a corrupted database and not sure where to look. If someone can give me a hint?? Here are the symtoms:
Expense table. Accounts Table. Expense amount posts to accounts based on account number. Expense "lookup" from account table for account number and account name. Account name from accounts table fills in expense "purpose" based on account number.
NO, I can't restore to an earlier backup due to structure changes made since problem showed up.
OK: Symptoms:
1. Enter an expense. Enter account number and amount. The amount posts to accounts table in the account number one number higher than it should. If I enter an expense to accout 6100, it posts to 6150.
2. I have subtract on delete rule. If I delete an expense for account 6100, the program posts to accounts and subtracts the amount from account 6150, one higher than it is supposed to.
3. If I look at the expense table, the account number is correct but it posted to accounts in the next higher account number.
4. After an expense has been entered. If I go to the expense table and try to change the account number, say from 6100 to 7100, I enter 7100 in the account number field and, as soon as I tab away from it, it changes to 7200, the next number up.
The only way to make it stop is to delete the posting and lookup field rules. Rebuilding them brings the problem back again.
I tried to make this as simple as I could but I know it ain't easy when reading someone else's descriptions.
Jim
Expense table. Accounts Table. Expense amount posts to accounts based on account number. Expense "lookup" from account table for account number and account name. Account name from accounts table fills in expense "purpose" based on account number.
NO, I can't restore to an earlier backup due to structure changes made since problem showed up.
OK: Symptoms:
1. Enter an expense. Enter account number and amount. The amount posts to accounts table in the account number one number higher than it should. If I enter an expense to accout 6100, it posts to 6150.
2. I have subtract on delete rule. If I delete an expense for account 6100, the program posts to accounts and subtracts the amount from account 6150, one higher than it is supposed to.
3. If I look at the expense table, the account number is correct but it posted to accounts in the next higher account number.
4. After an expense has been entered. If I go to the expense table and try to change the account number, say from 6100 to 7100, I enter 7100 in the account number field and, as soon as I tab away from it, it changes to 7200, the next number up.
The only way to make it stop is to delete the posting and lookup field rules. Rebuilding them brings the problem back again.
I tried to make this as simple as I could but I know it ain't easy when reading someone else's descriptions.
Jim
Comment