paulwilliams
Registered User.
- Local time
- Today, 08:23
- Joined
- Jul 27, 2012
- Messages
- 10
Hi All
In simple terms, I have a call logging sheet that asks account managers to choose an account name from a list and then add details about a call before saving back to the 'CallSheet' table. There is an 'AccountManager' table that lists the names of all account managers. There is also a 'Customer' table that stores the customer names, codes and the name of the Principle Account Manager. The tables are related by 1-many relationship from [Customer].[ID] to [CallSheet].[Customer] respectively and a 1-many relationship between [AccountManager].[ID] to [Customer].[PrincipleACM] respectively. There are other tables and relationships too but I have systematically removed these so I know they are not causing the problem.
I have a form that I view as a Datasheet. It lists all fields from the 'Callsheet' table along with the name of the Principle ACM from the 'AccountManager' table. Data is displayed fine. If you apply a filter to the 'Customer' column it also applies without a problem. However, with a filter applied, if you then click the filter icon in the column header and error message appears "Microsoft Access. Could not find field 'Customer'". Having acknowleged the error you can continue to use the filter without a problem.
Some articles have suggested that this may be corruption in the data causing the issue. I have removed and re-established the relationships between the tables, with enforced referential integrity to ensure there are no integrity errors. I have run 'compact and repair' and have even imported the contents of the database to a new database using the import tool in access. the problem remains however.
I'd really appriciate any feedback if anyone has seen this problem before or if you know how to troubleshoot/fix it.
Many thanks in advance,
Paul
In simple terms, I have a call logging sheet that asks account managers to choose an account name from a list and then add details about a call before saving back to the 'CallSheet' table. There is an 'AccountManager' table that lists the names of all account managers. There is also a 'Customer' table that stores the customer names, codes and the name of the Principle Account Manager. The tables are related by 1-many relationship from [Customer].[ID] to [CallSheet].[Customer] respectively and a 1-many relationship between [AccountManager].[ID] to [Customer].[PrincipleACM] respectively. There are other tables and relationships too but I have systematically removed these so I know they are not causing the problem.
I have a form that I view as a Datasheet. It lists all fields from the 'Callsheet' table along with the name of the Principle ACM from the 'AccountManager' table. Data is displayed fine. If you apply a filter to the 'Customer' column it also applies without a problem. However, with a filter applied, if you then click the filter icon in the column header and error message appears "Microsoft Access. Could not find field 'Customer'". Having acknowleged the error you can continue to use the filter without a problem.
Some articles have suggested that this may be corruption in the data causing the issue. I have removed and re-established the relationships between the tables, with enforced referential integrity to ensure there are no integrity errors. I have run 'compact and repair' and have even imported the contents of the database to a new database using the import tool in access. the problem remains however.
I'd really appriciate any feedback if anyone has seen this problem before or if you know how to troubleshoot/fix it.
Many thanks in advance,
Paul