queries is not updatable (1 Viewer)

MK1999

New member
Local time
Today, 15:56
Joined
Mar 30, 2022
Messages
24
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!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:56
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!

Is there any way you can simplify your query, so you can update the data?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:56
Joined
Feb 19, 2002
Messages
42,981
It isn't the number of tables in a query that makes it not updateable. It is the joins and PKs not being correctly defined as mentioned in the list posted by @isladogs along with many other issues.
 

Users who are viewing this thread

Top Bottom