Full Moon
05-02-2007, 03:45 AM
hi there i am getting this error message when i tired to insert new record in the job table
"You cannot add or change a record because a related record is required in table ''
in fact the job table have many to one relationship with users table
one user can do more than one job, but one job can be done by only one user
And i put User_No as foreign key in the jobs table, which is autonumber in the User table
any one know what is the problem?!
"You cannot add or change a record because a related record is required in table ''
in fact the job table have many to one relationship with users table
one user can do more than one job, but one job can be done by only one user
And i put User_No as foreign key in the jobs table, which is autonumber in the User table
any one know what is the problem?!