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.



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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.