Solved ACCESS RELATIONS ISSUE

[georg0307]

Dear all,
I receive a strange error depending the relation one to many:

See attached file.

 

[mike60smart]

Dear all,
I receive a strange error depending the relation one to many:
View attachment 88637
See attached file.

Hi George
The error indicates that you have records in your Registro Table without matching records in the Pn_Qty_TBL

If you look at your Registro Table you have records numbered 1 through to 12 on the Primary Key

In your Pn_Qty_TBL you have records numbered 14, 15 and 16 on the ID related Foreign Key.

In the attached I renumbered the ID Foreign Keys in the table Pn_Qty_TBL with the numbers 1, 2 and 3

I then set a true 1 to Many relationship.

Hope this helps?

 

[Isaac]

I don't understand that error, either.

 

[mike60smart]

Hi Isaac

Is it my explanation you are not following?

 

[Isaac]

Was directed at the OP, as a subtle way of suggesting what may be the relative wisdom, or lack thereof, of posting an error message in another language and looking for help.

 

[mike60smart]

Too true I have the same difficulty

 

[georg0307]

Hi George
The error indicates that you have records in your Registro Table without matching records in the Pn_Qty_TBL

If you look at your Registro Table you have records numbered 1 through to 12 on the Primary Key

In your Pn_Qty_TBL you have records numbered 14, 15 and 16 on the ID related Foreign Key.

In the attached I renumbered the ID Foreign Keys in the table Pn_Qty_TBL with the numbers 1, 2 and 3

I then set a true 1 to Many relationship.

Hope this helps?

Hi,
many thanks for help. I understand, thnaks for transforming my errors in learning.
Georg