Re: [libreoffice-users] Relationships in Base
Hi :) The best place for documentation is https://wiki.documentfoundation.org/Documentation/Publications There are also some good video guides at http://www.spoken-tutorial.org/list_videos?view=1&foss=LibreOffice-Suite-Base&language=English although i haven't worked through the Base ones yet. I'm still hoping that someone else here will be able to give better guidance about using Base. Good luck and regards from Tom :) On 21 November 2013 14:23, Doug Essinger-Hileman wrote: > On 11/20/2013 4:16 PM, Tom Davies wrote: > >> Hi :) >> Sorry for the delay! We seem to be a little slow in the last couple of >> weeks. > > > No problem. Thanks for the reply. > > >> The 2nd table probably needs it's own ID field (yes, it's the right >> term) even though it's not really going to be used at all. Is each >> row in the 2nd table unique to a Contact? or do some contacts have >> more than 1 row in the 2nd table? >> >> I suspect that the Event Table needs to be a Query rather than a >> table. Queries look a lot like tables. It might need to be a Form >> instead though and i would build Forms by basing them on Queries. The >> Query would pull the information from both tables together then the >> Form might be what you need to be able to type a name into in order to >> get the details of that row of the Query. >> >> I'm kinda clutching at straws here but i think you need to check on 3 >> things >> 1. Give the 2nd table it's own ID >> 2. Check the type of relationship linking the Connections table to >> the 2nd one (ie 1 to 1, 1 to many, or many to 1, (many to many seems >> unlikely!)) >> 3. Try using an external back-end to store your data tables rather >> than the internal one built-in >> >> How you do that 3rd thing is still a bit beyond me but there are tools >> such as Postgresql, MySql/MariaDB, HsqlDB and many others. I don't >> know which is best but it probably depends on how large the tables are >> likely to be. For any kind of contacts database it's likely to be >> reasonably small so you could aim for the small, light and fast ones. >> > > And thanks for the info. I'm off to read up on queries. I'm sure I'll have > some more questions, and will ask them as they arise. > > > Doug > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Relationships in Base
On 11/20/2013 4:16 PM, Tom Davies wrote: Hi :) Sorry for the delay! We seem to be a little slow in the last couple of weeks. No problem. Thanks for the reply. The 2nd table probably needs it's own ID field (yes, it's the right term) even though it's not really going to be used at all. Is each row in the 2nd table unique to a Contact? or do some contacts have more than 1 row in the 2nd table? I suspect that the Event Table needs to be a Query rather than a table. Queries look a lot like tables. It might need to be a Form instead though and i would build Forms by basing them on Queries. The Query would pull the information from both tables together then the Form might be what you need to be able to type a name into in order to get the details of that row of the Query. I'm kinda clutching at straws here but i think you need to check on 3 things 1. Give the 2nd table it's own ID 2. Check the type of relationship linking the Connections table to the 2nd one (ie 1 to 1, 1 to many, or many to 1, (many to many seems unlikely!)) 3. Try using an external back-end to store your data tables rather than the internal one built-in How you do that 3rd thing is still a bit beyond me but there are tools such as Postgresql, MySql/MariaDB, HsqlDB and many others. I don't know which is best but it probably depends on how large the tables are likely to be. For any kind of contacts database it's likely to be reasonably small so you could aim for the small, light and fast ones. And thanks for the info. I'm off to read up on queries. I'm sure I'll have some more questions, and will ask them as they arise. Doug -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Relationships in Base
Hi :) Sorry for the delay! We seem to be a little slow in the last couple of weeks. The 2nd table probably needs it's own ID field (yes, it's the right term) even though it's not really going to be used at all. Is each row in the 2nd table unique to a Contact? or do some contacts have more than 1 row in the 2nd table? I suspect that the Event Table needs to be a Query rather than a table. Queries look a lot like tables. It might need to be a Form instead though and i would build Forms by basing them on Queries. The Query would pull the information from both tables together then the Form might be what you need to be able to type a name into in order to get the details of that row of the Query. I'm kinda clutching at straws here but i think you need to check on 3 things 1. Give the 2nd table it's own ID 2. Check the type of relationship linking the Connections table to the 2nd one (ie 1 to 1, 1 to many, or many to 1, (many to many seems unlikely!)) 3. Try using an external back-end to store your data tables rather than the internal one built-in How you do that 3rd thing is still a bit beyond me but there are tools such as Postgresql, MySql/MariaDB, HsqlDB and many others. I don't know which is best but it probably depends on how large the tables are likely to be. For any kind of contacts database it's likely to be reasonably small so you could aim for the small, light and fast ones. Regards from Tom :) On 20 November 2013 15:56, Doug Essinger-Hileman wrote: > Good morning. I'm new to this list, and thought it polite to introduce > myself before I ask for help. So . . . > > My professional career is one which has travelled a long and winding road. I > began my university career studying aerospace engineering before deciding to > become a parish pastor in United Methodist and Presbyterian congregations, > where I served for about 27 years. Then I apprenticed and worked as a baker > of bread for 6 years. Now, I am the co-Founding Pastor of a new church > development (which will combine ministry and baking -- it's a story I'm > happy to share, but one which is likely not germane to this email). > > When I was in parish ministry, my wife and I used Lotus SmartSuite, > including its relational database, Approach. I believe I was fairly > proficient at it for the needs I had. But it's been 6 years of so, which > means my skills are rather rusty -- and we've switched to LibreOffice, which > means that some things are done in a slightly different manner. And I've > found I need some help. > > I am creating a relational database of our friends and followers. The first > table I created was one called "Connections," because it is a "master table" > keeping track of all the folk with whom we make some sort of connection. As > you might guess, the fields (is that the terminology used nowadays?) include > a CID (connection ID), which is an auto-incremented ID number field and the > primary key, first and last name, address and other contact fields, etc. > > I am now creating a second table to record the information about contacts we > had with our connections during a particular fundraising event. My thought > on the design of this table is that it would have the connection's CID, > name, and the amount they donated. I figured that I'd again make the CID the > primary key for this table, and create a relationship between those fields > in the two tables. I would also like it set up so that I can enter the name > in the event table and the rest of the information will be pulled in from > the other table. > > I created the new table and linked the two CID fields. But when I enter the > name in the event table, it doesn't automatically pull up the information > from the other table. > > Any help would be greatly appreciate. > > Doug > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Relationships in Base
Good morning. I'm new to this list, and thought it polite to introduce myself before I ask for help. So . . . My professional career is one which has travelled a long and winding road. I began my university career studying aerospace engineering before deciding to become a parish pastor in United Methodist and Presbyterian congregations, where I served for about 27 years. Then I apprenticed and worked as a baker of bread for 6 years. Now, I am the co-Founding Pastor of a new church development (which will combine ministry and baking -- it's a story I'm happy to share, but one which is likely not germane to this email). When I was in parish ministry, my wife and I used Lotus SmartSuite, including its relational database, Approach. I believe I was fairly proficient at it for the needs I had. But it's been 6 years of so, which means my skills are rather rusty -- and we've switched to LibreOffice, which means that some things are done in a slightly different manner. And I've found I need some help. I am creating a relational database of our friends and followers. The first table I created was one called "Connections," because it is a "master table" keeping track of all the folk with whom we make some sort of connection. As you might guess, the fields (is that the terminology used nowadays?) include a CID (connection ID), which is an auto-incremented ID number field and the primary key, first and last name, address and other contact fields, etc. I am now creating a second table to record the information about contacts we had with our connections during a particular fundraising event. My thought on the design of this table is that it would have the connection's CID, name, and the amount they donated. I figured that I'd again make the CID the primary key for this table, and create a relationship between those fields in the two tables. I would also like it set up so that I can enter the name in the event table and the rest of the information will be pulled in from the other table. I created the new table and linked the two CID fields. But when I enter the name in the event table, it doesn't automatically pull up the information from the other table. Any help would be greatly appreciate. Doug -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Relationships in Base
On Mon, 2012-02-27 at 02:36 -0800, gerbreown wrote: > I have just started using LO Base 3.4.4. I created 2 tables with a > relationship between them. I then deleted one of the tables and created > another one with a relationship to the first. When I try to add records to > the table is gives me the following error message: "SQL Status: 23000 > Error code: -177 > > Integrity constraint violation - no parent SYS_FK_110 table: Patient Old in > statement [INSERT INTO "Pharm Rcpt" ( > "pr_Cost","pr_Date","pr_Doctor","pr_Med","pr_Patient","pr_Pharm","pr_Qty") > VALUES ( ?,?,?,?,?,?,?)]" > > It looks like the relationship did not get deleted when the table was > deleted. When you have the database opened, use Tools > Relationships to define relationships between tables or to delete relationships. What I would like to know is the specific steps you used to create the relationship between the two tables? How did you add the second relationship you mentioned? --Dan -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Relationships in Base
I have just started using LO Base 3.4.4. I created 2 tables with a relationship between them. I then deleted one of the tables and created another one with a relationship to the first. When I try to add records to the table is gives me the following error message: "SQL Status: 23000 Error code: -177 Integrity constraint violation - no parent SYS_FK_110 table: Patient Old in statement [INSERT INTO "Pharm Rcpt" ( "pr_Cost","pr_Date","pr_Doctor","pr_Med","pr_Patient","pr_Pharm","pr_Qty") VALUES ( ?,?,?,?,?,?,?)]" It looks like the relationship did not get deleted when the table was deleted. -- View this message in context: http://nabble.documentfoundation.org/Relationships-in-Base-tp3780236p3780236.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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