Re: [libreoffice-users] Base List Tables Questions
Dave On Thu, 2011-08-25 at 16:46 -0400, dave boland wrote: I'm creating a database that has a main table and a few list tables to supply data for list boxes. I have been following the User Guide and created three list tables. When I go to link them I get errors about the keys. The errors make no sense to me, so what I need is a complete procedure on how to do this (would also suggest updating the documentation). What is the error message, you may need a series of one-to-one links between the list tables and the main table. I suspect you will need a foreign key for each list table in the main table. The main table will look like this: ID, Integer // Key Date, Date EmployeeName, text VARCHAR EmployeeAddr, text VARCHAR EmployeeType, text VARCHAR EmployeeDept, text VARCHAR EmployeePos, text VARCHAR EmployeeTypeID, Integer (Foreign Key to EmployeeType table) EmployeeDeptID, Integer (Foreign Key to EmployeeDepartment table) EmployeePosID, Integer (Foreign Key to EmployeePos) tMainTable: -- ID, Integer // Key Date, Date EmployeeName, text VARCHAR EmployeeAddr, text VARCHAR EmployeeType, text VARCHAR EmployeeDept, text VARCHAR EmployeePos, text VARCHAR tEmployeeType: --- EmployeeType, text VARCHAR EmployeeTypeID, INTEGER// Autovalue = yes, key tEmployeeDept: --- EmployeeDept, text VARCHAR EmployeeDeptID, INTEGER// autovalue = yes, Key tEmployeePos: --- EmployeePos, text VARCHAR EmployeePosID, INTEGER // autovalue = yes, Key One other question -- how can I print out the table design (Edit view)? Thanks, Dave -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Or how I learned to stop worrying and love email again -- Jay Lozier jsloz...@gmail.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
Re: [libreoffice-users] Base List Tables Questions
planas, I suspect you are on to something here. The error (detailed version) is: SQL Status: S0011 Error code: -170 Primary or unique constraint required on main table: tEmployeeType in statement [ALTER TABLE tMainTable ADD FOREIGN KEY (EmployeeType) REFERENCES tEmployeeType (EmployeeType)] It looks like the relationship system is trying to add a key to tMainTable, but can't for some reason. Dave, -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Does exactly what it says on the tin -- 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
Re: [libreoffice-users] Base List Tables Questions
Dave On Thu, 2011-08-25 at 18:25 -0400, dave boland wrote: planas, I suspect you are on to something here. The error (detailed version) is: SQL Status: S0011 Error code: -170 Primary or unique constraint required on main table: tEmployeeType in statement [ALTER TABLE tMainTable ADD FOREIGN KEY (EmployeeType) REFERENCES tEmployeeType (EmployeeType)] It looks like the relationship system is trying to add a key to tMainTable, but can't for some reason. Dave, You can manually insert the each column into main. Under TOOLS select RELATIONSHIPS. On the selection menu add the tables. Then under TOOLS (I believe) select ADD Relationship. You then select the two keys that are related Main.EmployeesID and Employees.EmployeeID (the correct foreign key in Main with the key field of the table you are linking) -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Does exactly what it says on the tin -- Jay Lozier jsloz...@gmail.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