In: Computer Science
The ProjectsAndLineItems query currently uses the ProjectID field from the Projects table. Explain why that field cannot be edited in Query Datasheet View.
The ProjectID field is the primary key field in the Projects table. As such, it cannot be modified in Query Datasheet View because doing so would orphan related records in the ProjectLineitems table. Furthermore, the ProjectID field is created with an AutoNumber data type, which doesn’t allow manual modifications in the first place.
ProjectID in Projects table is primary key, preventing modification in Query Datasheet View, ensuring relational integrity.