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
>   dboland9@fastmail.fm
>
> -- 
> http://www.fastmail.fm - Or how I learned to stop worrying and
>                           love email again



-- 
Jay Lozier
jslozier@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@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