Hi,
i'm trying to design a simple access db to manage a small amount of asset that I am renting.
What I want is to be able to add existing asset to an order via a subform in a form but when I try to add items via my combo box in the subform i've got the error : " Cannot add record;join key of " table" is not in recordset.
I've took this demo for example to develop my form, but he skip a lot of step in his tutorial and i can't figure out what i'm doing wrong in my case: https://www.youtube.com/watch?v=E_nMGZYlvSM
here an example of the relationship :
here is the problem :
here is the file :
Database4.zip
I am pretty sure the solution is pretty easy but I can't find how to do it.
Thanks for anyone who can told me how to solve that !