I have a database for entering customer, jobs and tasks for each job. All are connected by a customer ID (Customer to Jobs) and Job Id (Jobs to Tasks). I created a form to enter the customer and subform for the jobs and a subform for the tasks. In the Customer form the Customber ID is a autonumber. In the Jobs Subform the Customer ID points to the Customer ID in the Customer form and the Job ID is an autonumber. In the Tasks subform, the JobID points to the Job ID in the Job Subform (got all that!). My problem is when I try to add a new Job I get the following error messages " You can't assign a value to this Object" and " You cannot add or change a record because a realted record is required in the table "Customer". Any suggestions?
Kristin
Kristin
