Apache OpenOffice Community Forum

Hi

I have a form with fields from a table
some of the fields, when I type in text it goes on every record!
seems to happen with only two of the fields
not sure why how do I change this?

thank you for your help

We need more information about your tables, field structure and form.

Hi I enclosed a test database I copied mine and changed the personal data
when I input data in "horse property" and "acres" that info shows up on every record which of course changes any previous info I put in
this doesn't happen with the other fields I must be missing something but I am not sure what

I have a MacBook Air Sierra 10.12.6

thank you

The problem is that the text box controls for Horse Property and Acres on your form document are not connected to any table fields.
Open Buyer Client form document in the Edit/Design mode.
Right click on the text box for Horse Property and select Control to open the Properties: Text Box dialog.
On the Data tab select the down arrow to the right of Data field and select horse property from the list of fields.
Likewise, set the Data field to acres for the Acres text box.
Exit the Design mode and test the form. It should save what you type in those text boxes in the appropriate fields in the Buyer client table.

Thank you Thank you !!!!!!
I spent some time checking things but wasn't sure what to look for