Why is my qry not updateable

[alguzman]

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....

 

[alguzman]

Pat Hartman you are right. My tables resemble your second example. I had to make one table within the qry a one-to-one relationship. The tables make up is exhibitorID, address, city, st,zip, the other table is PaymentID (autonumber, Keyfield) exhibitorID, payments and the last table is boothID(autonumber and keyfield) exhibitorID and boothnumbers. I changed the boothnumbers table and took out the autonumber field and left the exhibitorID as a one to one relationship. Is that good database design?? Do you have any suggestions....

Thanks again for your help