<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi All<br>
There seems not to be urgency to enable kexi to create composite
primary keys.<br>
Then there must be another way to do the following
three tables?<br>
I thought you could only do it via a composite primary key.<br>
<br>
Many plants can have the same common name and many plants can have many
common names.<br>
(I created the original layout for OOOBase)<br>
Cheers<br>
Max<br>
<br>
<table border="0" cellspacing="0" cols="7" frame="VOID" rules="NONE">
<tbody>
<tr>
</tr>
<tr>
<td
style="border-top: 1px solid rgb(0, 0, 0); border-left: 1px solid rgb(0, 0, 0);"
height="19" width="92" align="LEFT"><b>Plants.tbl</b></td>
<td style="border-top: 1px solid rgb(0, 0, 0);" width="56"
align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" width="116"
align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" width="38"
align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" width="38"
align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" width="38"
align="LEFT"><br>
</td>
<td
style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0);"
width="190" align="LEFT"><br>
</td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT"><b>Field Name</b></td>
<td colspan="2" valign="MIDDLE" align="CENTER"><b>Field Type</b></td>
<td align="LEFT"><b>Req</b></td>
<td align="LEFT"><b>Len</b></td>
<td align="LEFT"><b>Key</b></td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><b>Comment</b></td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT">PlantID</td>
<td align="LEFT">Integer</td>
<td align="LEFT">INTEGER</td>
<td align="LEFT">Yes</td>
<td sdval="10" sdnum="3081;" align="RIGHT">10</td>
<td align="LEFT">p</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT">BotName</td>
<td align="LEFT">Text </td>
<td align="LEFT">VARCHAR</td>
<td align="LEFT">Yes</td>
<td sdval="50" sdnum="3081;" align="RIGHT">50</td>
<td align="LEFT"><br>
</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT">Synonym</td>
<td align="LEFT">Text </td>
<td align="LEFT">VARCHAR</td>
<td align="LEFT">No</td>
<td sdval="50" sdnum="3081;" align="RIGHT">50</td>
<td align="LEFT"><br>
</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT">FamName</td>
<td align="LEFT">Integer</td>
<td align="LEFT">INTEGER</td>
<td align="LEFT">Yes</td>
<td sdval="10" sdnum="3081;" align="RIGHT">10</td>
<td align="LEFT"><br>
</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT">Listbox
from
FamName.tbl</td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="19"
align="LEFT">PlantDescript</td>
<td align="LEFT">Memo</td>
<td align="LEFT">LONGVARCHAR</td>
<td align="LEFT">Yes</td>
<td sdval="0" sdnum="3081;" align="RIGHT">0</td>
<td align="LEFT"><br>
</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
</tr>
<tr>
<td
style="border-left: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"
height="19" align="LEFT">ImagePath</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">Text
</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">VARCHAR</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">No</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" sdval="100"
sdnum="3081;" align="RIGHT">100</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td
style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"
align="LEFT"><br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<table border="0" cellspacing="0" cols="7" frame="VOID" rules="NONE">
<tbody>
<tr>
</tr>
<tr>
<td
style="border-top: 1px solid rgb(0, 0, 0); border-left: 1px solid rgb(0, 0, 0);"
height="19" align="LEFT"><b>PlantComName.tbl</b></td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td
style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0);"
align="LEFT"><b>Link table/Composite Key</b></td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT"><b>Field Name</b></td>
<td colspan="2" valign="MIDDLE" align="CENTER"><b>Field Type</b></td>
<td align="LEFT"><b>Req</b></td>
<td align="LEFT"><b>Len</b></td>
<td align="LEFT"><b>Key</b></td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><b>Comment</b></td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT">PlantID</td>
<td align="LEFT">Integer</td>
<td align="LEFT">INTEGER</td>
<td align="LEFT">Yes</td>
<td sdval="10" sdnum="3081;" align="RIGHT">10</td>
<td align="LEFT">p</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT">Plants.tbl
plantID</td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT">ComNameID</td>
<td align="LEFT">Integer</td>
<td align="LEFT">INTEGER</td>
<td align="LEFT">Yes</td>
<td sdval="10" sdnum="3081;" align="RIGHT">10</td>
<td align="LEFT">p</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT">ComName.tbl
ComNameID</td>
</tr>
<tr>
<td
style="border-left: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"
height="19" align="LEFT">ReferenceID</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">Integer</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">INTEGER</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">Yes</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" sdval="10"
sdnum="3081;" align="RIGHT">10</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">p</td>
<td
style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"
align="LEFT">Reference.tbl ReferenceID</td>
</tr>
</tbody>
</table>
<br>
<br>
<table border="0" cellspacing="0" cols="7" frame="VOID" rules="NONE">
<tbody>
<tr>
</tr>
<tr>
<td
style="border-top: 1px solid rgb(0, 0, 0); border-left: 1px solid rgb(0, 0, 0);"
height="19" align="LEFT"><b>ComName.tbl</b></td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td style="border-top: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td
style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0);"
align="LEFT"><br>
</td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT"><b>Field Name</b></td>
<td colspan="2" valign="MIDDLE" align="CENTER"><b>Field Type</b></td>
<td align="LEFT"><b>Req</b></td>
<td align="LEFT"><b>Len</b></td>
<td align="LEFT"><b>Key</b></td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><b>Comment</b></td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(0, 0, 0);" height="17"
align="LEFT">ComNameID</td>
<td align="LEFT">Integer</td>
<td align="LEFT">INTEGER</td>
<td align="LEFT">Yes</td>
<td sdval="10" sdnum="3081;" align="RIGHT">10</td>
<td align="LEFT">p</td>
<td style="border-right: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
</tr>
<tr>
<td
style="border-left: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"
height="17" align="LEFT">ComName</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">Text
</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">VARCHAR</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT">Yes</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" sdval="50"
sdnum="3081;" align="RIGHT">50</td>
<td style="border-bottom: 1px solid rgb(0, 0, 0);" align="LEFT"><br>
</td>
<td
style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"
align="LEFT"><br>
</td>
</tr>
</tbody>
</table>
<br>
</body>
</html>