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

2013-11-28 Thread Scott Castaline
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 bo

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

2013-11-27 Thread Alexander Thurgood
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 yo

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

2013-11-27 Thread Scott Castaline
On 11/17/2013 04:53 AM, Alexander Thurgood wrote: Le 17/11/13 06:32, Scott Castaline a écrit : Hi Scott, So how would I do that in the graphical tool? I can't seem to get it to work. I vaguely remember working with foreign keys and the sql statement would refer to AlbumID from the parent as Al

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

2013-11-17 Thread Scott Castaline
On 11/17/2013 04:53 AM, Alexander Thurgood wrote: Le 17/11/13 06:32, Scott Castaline a écrit : Hi Scott, So how would I do that in the graphical tool? I can't seem to get it to work. I vaguely remember working with foreign keys and the sql statement would refer to AlbumID from the parent as Al

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

2013-11-17 Thread Alexander Thurgood
Le 17/11/13 06:32, Scott Castaline a écrit : Hi Scott, > So how would I do that in the graphical tool? I can't seem to get it to > work. I vaguely remember working with foreign keys and the sql statement > would refer to AlbumID from the parent as Album.AlbumID for both tables. > Wouldn't I also

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

2013-11-16 Thread Scott Castaline
On 11/16/2013 02:25 PM, Jay Lozier wrote: On Sat, 2013-11-16 at 12:01 -0500, Scott Castaline wrote: I haven't worked with SQL DBs since the late 80's so I'm not sure what I'm doing wrong here. I have created a BASE DB using the internal HSQLDB engine for my music collection containing different

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

2013-11-16 Thread Jay Lozier
On Sat, 2013-11-16 at 12:01 -0500, Scott Castaline wrote: > I haven't worked with SQL DBs since the late 80's so I'm not sure what > I'm doing wrong here. I have created a BASE DB using the internal HSQLDB > engine for my music collection containing different media (CDs, DVDs, > Vinyl LPs, 45s

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

2013-11-16 Thread Scott Castaline
I haven't worked with SQL DBs since the late 80's so I'm not sure what I'm doing wrong here. I have created a BASE DB using the internal HSQLDB engine for my music collection containing different media (CDs, DVDs, Vinyl LPs, 45s and Cassette, wife had thrown out all my 8-tracks back in '98 as w