Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


On 11/27/2013 11:08 AM, Alexander Thurgood wrote:
Le 27/11/13 15:24, Scott Castaline a écrit :

Hi Scott,

What am I not doing? I'm thinking of changing one other field this way
and was doing this one to figure out doing it.
 From your description, it sounds like you have not set the correct bound
field in the properties of your Combobox on your main form.

Enter Design mode for your main form, and then select the control you
want to edit, or if you have both a control and associated label, enter
the group first (right mouse button click on the control in question >
Edit/Enter group). From here, you need to make sure that your box is
bound to the right data source in the Data tab, and the correct field,
or alternatively, make the population of that field dependent on a SQL
statement that basically just says "SELECT * FROM
fieldusedtopopulateform". Save the form, leave edit mode and see if it
now works.


Alex





Alex,

I went back into the design mode and found that I hadn't completely setup the data page in the field control settings. Once I did that when I clicked on the arrow a drop down box appeared with 5 lines from the corresponding table. I assumed it was working fine, so I proceeded to do the same with 2 other fields. I created the tables for them, initially populated them with data, setup the relations with the main table. Again all seemed to be working fine. I was able to either click the arrow for the drop down to list the different values or start typing in the value and it would attempt to complete based on what was in the corresponding table and what I had typed so far.
This afternoon I went back into the db and the main table's form when I 
noticed that the fields involved were displaying what I had entered for 
the last record created/edited. If I changed it to correct it I found 
that for all records that field remained the same. Since so far I've 
only been entering info from CDs and have not started with any vinyl yet 
so that field would be the same as well as the genre since I've also 
been entering in from a collection of the same genre, but the field in 
question is the one that tracks where I purchased the media from. That 
field is the one that is supposed to change for at least 2 of the 20 CDs 
I've entered so far. That was how I noticed that something was wrong. 
I've also noticed that when I go into Edit mode of the form some fields 
will display data as though I'm in data entry mode and not design mode. 
I don't know if this is related or something else happening.
I've tried several different combinations of settings for these fields 
whit no resolve of problem. On the data page of the field control I 
have; for Data Fields I have it pointing to the field that has the data 
I'm using to fill in the main table. for the next 2 settings I have left 
on default "yes", the type of list contents = Table and List content = 
name of table that I'm linked to. It seems to me that somehow the 
relations aren't working the way I want them to. It's applying the same 
record(s) from the linked table(s) to all records in the main table.
I have the same type of field settings for the primary keys as I do for 
the main table calling it the table name_ID set as an integer with 
AutoValue set. I then added on reference of these fields as foreign keys 
in the main table. The relations were set using the GUI by clicking on 
the the corresponding fields with the 1 end to the list tables and the N 
end to the foreign key field in the main table. Maybe it should be the 
other way or many to many, but I don't see how to do that. It seems that 
the GUI automatically sets the relation as 1 to N and the directions as 
well.
Again thanks.

Scott C.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.