Cannot add record(s); join key of table ' ' not in recordset.

[BartusZak]

Hey, guys!


Thanks for adding me to that group..
regarding to my problem
"You can not add a record in the recordset lack of key feedback table"
I have created 3 tables with 3 primary keys:
a) id_client (first tabel)
b) id_transaction (2nd tabel)
d) id_equip (3rd tabel)
2nd table has 2 relations ("id_client" from 1st table - to 2nd table "id_client"
When i'm using form to add "time of transaction" something like that appears and i'm not able to write anything

http://screenshot.sh/odCfjiLavRIGy - RELATIONS

Error msg :
http://screenshot.sh/m2f1Ck0LbhU8G
Thanks a lot for any help there !
Greetings
Bart

[CJ_London]

rule is one form one table - sound like you have one form three tables.

The 'primary' table or a query based on it alone should be on the main form, the related tables in subforms

[BartusZak]

rule is one form one table - sound like you have one form three tables.

The 'primary' table or a query based on it alone should be on the main form, the related tables in subforms

RELATIONS


TABLE "TRANZAKCJE"


I still don't have any idea how to fix the problem :<

[orange]

Perhaps you could try again to describe the problem in simple terms, and provide specific example highlighting the expected and observed values.
As ajax has advised, you would normally use form/subform to deal with 1 to Many relationship.
And 1 Form 1 Table is the general approach.