Unanswered: Cannot add record(s); join key of table not in recordset.
I'm a student of accountancy and I have a class which consist in creating a database in access.
We learned the very basic of access.
My problem is:
I'm creating a BD which consists in a company which have "several banks".
So I created the several tables:
Bank, Clients, Accounts, Manager.
BAN_CLI_MAN - would associate the clients and managers in the respective bank.
CLI_MAN_ACC - would associate the accounts and the managers of the accounts in the respective client.
Its all n:n so a ternary case.
I wanted to create a form of accounts which would have the fields Clients and Manager also, which would come from CLI_MAN_ACC table updating this table with the respective info client - account - account manager. I created the form and when I tried to add any info to the fields clients or manager it give me the error in the title, but if I change the form to a new record or existing one and then come back to the one I was creating it allows me to add info into the clients and manager fields, and updating the table without any problem.
Can you guys help me solve this problem, so I can finish my database project?