B
bondtk
I'm having an issue where my query will not allow new records to be added. I
know I've created queries before based upon multiple tables and you can add
new records. I believe my relationships are set properly outside the query.
Here is my scenario:
The database is to collect ratings customers provide on our services. I
have a main table for collecting general customer information and the
product, then a table just for ratings the customer provides. There can be
multiple ratings per service. So the tables have a one-to-many relationship.
I then have a 3rd table that list the rating choices (exceptional, very
good, satisfactory, marginal, unsatisfactory) with their corresponding
numeric values (5, 4, 3 2, 1). So I created a query with these three tables
together. The one-to-many relationship shows but every time I add the 3rd
table with the rating choices and numeric values, the query then doesn't
allow new records. The one thing I need from this 3rd table is the numeric
value. The user chooses the rating (very good, etc.) and then I want the
query to return the corresponding number. What am I overlooking here? I
even link the 3rd table to the main table by the rating but doesn't matter.
Just having the 3rd table in the window above in the query disables new
records. Any help would be appreciated!
Troy
know I've created queries before based upon multiple tables and you can add
new records. I believe my relationships are set properly outside the query.
Here is my scenario:
The database is to collect ratings customers provide on our services. I
have a main table for collecting general customer information and the
product, then a table just for ratings the customer provides. There can be
multiple ratings per service. So the tables have a one-to-many relationship.
I then have a 3rd table that list the rating choices (exceptional, very
good, satisfactory, marginal, unsatisfactory) with their corresponding
numeric values (5, 4, 3 2, 1). So I created a query with these three tables
together. The one-to-many relationship shows but every time I add the 3rd
table with the rating choices and numeric values, the query then doesn't
allow new records. The one thing I need from this 3rd table is the numeric
value. The user chooses the rating (very good, etc.) and then I want the
query to return the corresponding number. What am I overlooking here? I
even link the 3rd table to the main table by the rating but doesn't matter.
Just having the 3rd table in the window above in the query disables new
records. Any help would be appreciated!
Troy