Hey,
I'm using Access 2000 with several tables. I'm trying to change a form that allows user to enter time worked on a specific project. Once they select the Project, in another combo box they select the customer of that project. Upon submitting I get the error, 'You cannot add or change a record because a related record is required in tblTasks'.
The customer combo box is bound to the Customer and the row source is the project table, since every project is linked to one customer. Table tasks contains the task that can be done for the customers. I've checked the relationships amongst the tables and I think I'm got everything present. I also made sure I didn't have any autonumber fields linked together.
What am I missing????
Can someone please help me.
I'm using Access 2000 with several tables. I'm trying to change a form that allows user to enter time worked on a specific project. Once they select the Project, in another combo box they select the customer of that project. Upon submitting I get the error, 'You cannot add or change a record because a related record is required in tblTasks'.
The customer combo box is bound to the Customer and the row source is the project table, since every project is linked to one customer. Table tasks contains the task that can be done for the customers. I've checked the relationships amongst the tables and I think I'm got everything present. I also made sure I didn't have any autonumber fields linked together.
What am I missing????
Can someone please help me.
