I have created a form from 2 tables, client and applicationform. applicationform joins to client twice, first link is for the client and its details, and the second link is for spouse to display the other details. In table form, it allows null value for spouseid which is correct, but in form view, it doesnt allow and gives an "The Microsoft Jet database engine can't find a record in the table <name> with key matching field(s) <name>. (Error 3101)"
can someone please tell me how to solve it, thx
can someone please tell me how to solve it, thx
