Hi there
I have two tables(in hundreds) within my database. What I am trying to do is create a shortcut for non-accountants so that journal entries are predefined according to certain transactions. It also has the flexibility to allow direct entry into the COA for those "out of the ordinary" transactions.
To enable this I have 2 tables. Table#1 is a subaccount transactions table, and table#2 the main chart of accounts transactions table.
I am able to base a append query on table two and associated tables to append correct attributions of transaction amounts to correct Table#2 accounts. The append query works perfectly.
However, I believe that the update query would be more suitable, as it would mean that if any edits are made later on to table#1 to a specific entry an update query will replace if the transaction is already in Table#2.To enable this, I have made an inital query, to calculate the attributions to the assorted accounts.
My problem is that I cannot get the second query - the update query to work.. I keep getting the error message upon execution of: "Operation must use an updatable query". This is weird. and I don't know what I am doing wrong. Any tips would be appreciated, meanwhile I will keep muddling through it.
I have two tables(in hundreds) within my database. What I am trying to do is create a shortcut for non-accountants so that journal entries are predefined according to certain transactions. It also has the flexibility to allow direct entry into the COA for those "out of the ordinary" transactions.
To enable this I have 2 tables. Table#1 is a subaccount transactions table, and table#2 the main chart of accounts transactions table.
I am able to base a append query on table two and associated tables to append correct attributions of transaction amounts to correct Table#2 accounts. The append query works perfectly.
However, I believe that the update query would be more suitable, as it would mean that if any edits are made later on to table#1 to a specific entry an update query will replace if the transaction is already in Table#2.To enable this, I have made an inital query, to calculate the attributions to the assorted accounts.
My problem is that I cannot get the second query - the update query to work.. I keep getting the error message upon execution of: "Operation must use an updatable query". This is weird. and I don't know what I am doing wrong. Any tips would be appreciated, meanwhile I will keep muddling through it.