Uneditable query

[Ramesh]

Hi,

I have 3 tables, StudentInfo, BatchStudents, and BatchInfo.

StudentInfo has StuID, Stuname, ContactInfo
BatchStudents has StuID, BatchID, StartDate
BatchInfo has BatchID, Subject, StaffName, Timing.

StudentInfo is entered as when a student registers.
BatchInfo is entered as a new batch starts.
BatchStudents is entered as a students joins a batch.

No problem with first 2 entries.
When I enter BatchStudents, i d like the name of the student, staff, subject
also to be displayed once i enter the student name. StuID and BatchID has
one to many relationship set.

But when i create a query to do this, the query displays all the info, but
becomes non editable. Am i trying to do something non workable, or am i
making a mistake somewhere?

Thanks for any input.
Ramesh

 

[Scottgem (MVP)]

Often a multi-table query will result in an uneditable one. The basic
answer is not to do editing in queries. Use a form instead. You can then
use subforms to display the related data.