I am missing something incredibly basic regarding query construction and would appreciate any help that can be provided.
I have constructed a number of queries in my database, which has to do with recruiting and hiring. I can make simple queries fine and well, but once I start a chain of more than two or three tables, I get in serious trouble.
To whit: the query I've put together for our hiring process calls on eight tables, one basic personnel table, one application/consideration table, and six others representing pieces of the hiring process (in six pieces because the application could end in any one of them and I want to normalize the data). The personnel and application/consideration tables have a basic inner join between them, while the six hiring tables are connected to the application table by left outer joins wherein the application/consideration table is the left in all joins. (In case I haven't explained this properly, I've included a picture of the query.)
The problem: The query can display the data with no trouble, but when I view it, it is in some way read-only. That is, it bars entering any new data, and when I attempt to type or click on yes/no fields, I get only the Windows Exclamation sound and nothing else.
I presume I am overlooking something very basic about the structure of queries-does anyone have any idea what it is, and if so, is it fixable?
I have constructed a number of queries in my database, which has to do with recruiting and hiring. I can make simple queries fine and well, but once I start a chain of more than two or three tables, I get in serious trouble.
To whit: the query I've put together for our hiring process calls on eight tables, one basic personnel table, one application/consideration table, and six others representing pieces of the hiring process (in six pieces because the application could end in any one of them and I want to normalize the data). The personnel and application/consideration tables have a basic inner join between them, while the six hiring tables are connected to the application table by left outer joins wherein the application/consideration table is the left in all joins. (In case I haven't explained this properly, I've included a picture of the query.)
The problem: The query can display the data with no trouble, but when I view it, it is in some way read-only. That is, it bars entering any new data, and when I attempt to type or click on yes/no fields, I get only the Windows Exclamation sound and nothing else.
I presume I am overlooking something very basic about the structure of queries-does anyone have any idea what it is, and if so, is it fixable?