I have one form called 'cheques' where i enter the total sum of each cheque. I use the 'date' field and 'total' field combined to create a third field called 'cheque id'(primary key). From a 'list box' i chose different clients for whom the 'total' cheque amount must be allocated.

so i double click on the appropriate client to open a new form (client commissions)which appears below the initial form (still open). This form is related to the 'cheques' form using 'cheque id'. i enter the commission amount and upon my exit to return to cheques form i get this error "you cannot add or change a record because a related record is required in cheques" If i disable the the relationship ('cheque id' one to many) it works fine. in the tables 'cheque id' shows up in both - so i am at a loss; james

Try saving the cheque first,