You have tried to enter a value into the join field in the many-only table of an outer join with no corresponding value in the join field of the "one" side table. First enter a record in the "one" side table with the desired key value. Then make the entry with the desired join field in the "many-only" table.