I have a databse with one main table and other link tables all one- to- many relationships. I made a qry using three tables the main and two of the many side tables. I would like to make some data entry to the qry that will update the main table. When I enter in a new date into the qry it says that recordset is not updateable. why is this. I had to change on table to a one-to-one relationship and I now can update the qry. why one-to-many relationships won't let you update the qry??? Any help would be good. P.S. I did read the help section of Access and tried to look it up using the Knowledge base from Microsoft and couldn't find a clear answer to this....