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
[Solved] Field data shows up on every record
[Solved] Field data shows up on every record
Last edited by shadow350 on Fri Aug 10, 2018 9:40 pm, edited 1 time in total.
open office 4.1.5
MacBook Air 10.12.6
MacBook Air 10.12.6
Re: Field data shows up on every record
We need more information about your tables, field structure and form.
OpenOffice 4.1.12 on Windows 10
Re: Field data shows up on every record
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
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
- Attachments
-
- test database.odb
- (16.21 KiB) Downloaded 194 times
open office 4.1.5
MacBook Air 10.12.6
MacBook Air 10.12.6
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Field data shows up on every record
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.
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.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Field data shows up on every record
Thank you Thank you !!!!!!
I spent some time checking things but wasn't sure what to look for
I spent some time checking things but wasn't sure what to look for
open office 4.1.5
MacBook Air 10.12.6
MacBook Air 10.12.6