Hello,
I have a database tracking invoice from diff vendors.I have 2 tables which have one to one relationship between them both of the tables have id which is set on autonumber.
I have a form that updates both the tables simultaneously today as I was trying to add a new record through the form I am getting this error "You cannot add or change record because a related record in required in the table".
I have no idea how to resolve this issue today all I did is added a new vendor in to my vendor combo box in the form and that is when this error started to appear.
What is happening is one of my table is getting updated but the other other one is not also the records numbers are also matching.
Please any advice or suggestions is more than welcomed.
Thanks,
Roger