Re: [libreoffice-users] Re: Base; Setting up relations between tables

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