Apache OpenOffice Community Forum

I've got a form that is based on a query so I can find a desired record and update it. It all works great, so I made a new query to find all the records of a particular client. The query works as expected. I then copied a form that I use for data entry, only this one uses the query. When I open the form, it asks for the client name and the form is populated with all the correct data and I can scroll through all the records associated with that client. But I can't change any of the data. I've looked at the form control and it's set for changes (Allow additions, allow modifications, allow deletions).

Is it because the query uses data from two different tables? Or because the form has multiple records after the query runs? (can't be that because the other form I have can have multiple records after the query search and it allows changes). I've looked at the controls of the two forms and don't see any differences.

Help?!

For table data to be edited, the HSQL database engine requires the Primary Key value to identify which record to update.
Does the query include the Primary Key for the table you want to edit?
Does the form have a control for the Primary Key for the table you want to edit?
The form control containing the Primary Key can be hidden from the user but it must exist on the form.

Wow, such a simple thing. Added the key to the list of fields in the query, never do anything with it, but it solved the problem.

Thank you!!!!!!!!

UnklDonald418 wrote:Does the form have a control for the Primary Key for the table you want to edit?
The form control containing the Primary Key can be hidden from the user but it must exist on the form.

Nope. No form control needed if the primary key is an auto-value. Just include the field in the form's data source.