I've build a cross-tab query that is a combination of two separate tables that I want to use to enter data. However, when I try entering data, it says the query isn't updatable.
The data for the query comes from two tables: one which lists locations and project names (those are the two keys), and the other which lists funding cost (field I want as value for crosstab query) for the location and project by year (the column heading of the crosstab). The keys of the second table are location, project, and year of funding.
Each location may have a different number of years for which funding for the projects at that location, hence why I used two tables to store the data. Example: location 1 may want to show funding for years 1, 2, and 3, while location 2 may want to show funding for years 1, 2, 3, and 4.
First question is, in general, can cross-tab queries be made updatable? Second question is how do I do that for my case described above?
The data for the query comes from two tables: one which lists locations and project names (those are the two keys), and the other which lists funding cost (field I want as value for crosstab query) for the location and project by year (the column heading of the crosstab). The keys of the second table are location, project, and year of funding.
Each location may have a different number of years for which funding for the projects at that location, hence why I used two tables to store the data. Example: location 1 may want to show funding for years 1, 2, and 3, while location 2 may want to show funding for years 1, 2, 3, and 4.
First question is, in general, can cross-tab queries be made updatable? Second question is how do I do that for my case described above?
