limited support for direct foreign key assignments