I've got a problem.
I've got two tables: master table (animators) and detail table (projects). UserID from the master table is passed on to the detail table, so the records created by a user are selected and showed. It all works, view, list, edit options work, but when a given user wants to add a new record, somehow the UserID is not passed on to the add form. With the referential integrity option ON, I can't add another record, I get the error : You cannot add or update a record because the foreign key value does not exist in the master table 'animators'. It does not exist, the form field is empty because it is not passed on to the form... why? No idea. Can anybody help?
Cannot add a record because the foreign key value not exist in master table
-
- User
- Posts: 5