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).
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 [email protected] -- http://www.fastmail.fm - Or how I learned to stop worrying and love email again -- For unsubscribe instructions e-mail to: [email protected] 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
