Hi all!
I'm glad to be a new member here
I am new in access... I had an issue that when I want to add a new record the textboxes are not updatable.. after searching I realize the query I use is not updatable too.
I have around 6 tables and 3 composite tables in the query program_trainer, program_trianee, and program_coordinater. After some searching I assume the problem causing because the composite tables do not have PFK when I tried to assign the programID, trainerID both as PFK I got an error "The changes you requested in the table were not successful because it will create duplicate values remove or redefine the index" the tables already have data.. any ideas of how this problem will be solved?
I am looking forward for your suggestions, Thank You!
I'm glad to be a new member here
I am new in access... I had an issue that when I want to add a new record the textboxes are not updatable.. after searching I realize the query I use is not updatable too.
I have around 6 tables and 3 composite tables in the query program_trainer, program_trianee, and program_coordinater. After some searching I assume the problem causing because the composite tables do not have PFK when I tried to assign the programID, trainerID both as PFK I got an error "The changes you requested in the table were not successful because it will create duplicate values remove or redefine the index" the tables already have data.. any ideas of how this problem will be solved?
I am looking forward for your suggestions, Thank You!