Member Avatar for kosay

hi
I have MS Access Data Base with tow tables table 1 has relashiship with Table 2
when I try edite tabe 1 error message shown tell me I can't edit table 1
do you have examble for this ?

  • 3 Contributors
  • 3 Replies
  • 89 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by M.Waqas Aslam
Member Avatar for adam_k

The exact error would really help.

Member Avatar for kosay

message is :
{"You cannot add or change a record because a related record is required in table 'Table1'."}

Member Avatar for M.Waqas Aslam

yes this error is only occurs when you want to edit foreign key , for example , if there is two table having fields . Stuid , name and table 2 has fields id , stuid ,in this situation if you want to edit value of Stuid in table then it is necessary that table1 has same value .in it . hope this will help you.

Regards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.