https://neowiki.neooffice.org/index.php?title=Establishing_Relationships&limit=250&action=history&feed=atomEstablishing Relationships - Revision history2024-03-28T16:18:14ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13650&oldid=prevLorinda: /* Creating the Relationship */ correct formatting of note2008-03-29T12:27:46Z<p><span class="autocomment">Creating the Relationship -</span> correct formatting of note</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:27, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 53:</strong></td>
<td colspan="2" align="left"><strong>Line 53:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the icon that looks like a block of blue cells with a green plus in the corner.</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the icon that looks like a block of blue cells with a green plus in the corner.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Window|Add Tables}} window that appears, click on '''AOU_Birdlist'''</td><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Window|Add Tables}} window that appears, click on '''AOU_Birdlist'''</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:'''Note: If you have not created any relationships yet, the {{Window|Add Tables}} window will open automatically. </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#</ins>:'''Note: If you have not created any relationships yet, the<ins style="color: red; font-weight: bold; text-decoration: none;">''' </ins>{{Window|Add Tables}} <ins style="color: red; font-weight: bold; text-decoration: none;">'''</ins>window will open automatically.<ins style="color: red; font-weight: bold; text-decoration: none;">''' </ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#If the '''Sightings''' Table does not appear in the relationship "map," add it as well.</td><td> </td><td style="background: #eee; font-size: smaller;">#If the '''Sightings''' Table does not appear in the relationship "map," add it as well.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#click on the the {{prefName|EnglishName}} field in the {{Window|AOU_Birdlist} sub-window; drag from there to the {{prefName|Bird_Name}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#click on the the {{prefName|EnglishName}} field in the {{Window|AOU_Birdlist<ins style="color: red; font-weight: bold; text-decoration: none;">}</ins>} sub-window; drag from there to the {{prefName|Bird_Name}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#click on the disk drive symbol in the toolbar to save the changes you have made, and close the window.</td><td> </td><td style="background: #eee; font-size: smaller;">#click on the disk drive symbol in the toolbar to save the changes you have made, and close the window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13638&oldid=prevLJ-Bettona: /* Creating a Unique Constraint */typo -replace While with with and to with in point 22008-03-29T10:53:54Z<p><span class="autocomment">Creating a Unique Constraint -</span>typo -replace While with with and to with in point 2</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:53, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 41:</strong></td>
<td colspan="2" align="left"><strong>Line 41:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Make a note of the exact table and field names involved. In this case '''AOU_Birdlist''' and '''EnglishName'''</td><td> </td><td style="background: #eee; font-size: smaller;">#Make a note of the exact table and field names involved. In this case '''AOU_Birdlist''' and '''EnglishName'''</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:''Note: There must not be any spaces in the field name. While Base will not allow you to create field names with spaces in them when using the wizard or Design view, Base will retain spaces in field names if you import a spreadsheet into Base as a table. When importing the AOU Birdlist, the field name was '''English Name''' (with a space). I had to edit the table and delete the space before the SQL command would work.''</td><td> </td><td style="background: #eee; font-size: smaller;">#:''Note: There must not be any spaces in the field name. While Base will not allow you to create field names with spaces in them when using the wizard or Design view, Base will retain spaces in field names if you import a spreadsheet into Base as a table. When importing the AOU Birdlist, the field name was '''English Name''' (with a space). I had to edit the table and delete the space before the SQL command would work.''</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#<del style="color: red; font-weight: bold; text-decoration: none;">While </del>the database open <del style="color: red; font-weight: bold; text-decoration: none;">to </del>the main window (the one with Tables, Queries, Forms, and Reports in the left hand column), go to the {{Menu|Tools}} menu and choose {{Menu|SQL...}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#<ins style="color: red; font-weight: bold; text-decoration: none;">With </ins>the database open <ins style="color: red; font-weight: bold; text-decoration: none;">in </ins>the main window (the one with Tables, Queries, Forms, and Reports in the left hand column), go to the {{Menu|Tools}} menu and choose {{Menu|SQL...}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Enter the following statement into the top portion of the {{Window|Execute SQL Statement}} window:</td><td> </td><td style="background: #eee; font-size: smaller;">#Enter the following statement into the top portion of the {{Window|Execute SQL Statement}} window:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:{{preBox|<nowiki>alter table "AOU_Birdlist" add constraint "uq_EngName" unique ("EnglishName" )</nowiki>}}</td><td> </td><td style="background: #eee; font-size: smaller;">#:{{preBox|<nowiki>alter table "AOU_Birdlist" add constraint "uq_EngName" unique ("EnglishName" )</nowiki>}}</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13637&oldid=prevLJ-Bettona: /* Creating a Unique Index */ typo - replace A with a after New Index point 62008-03-29T10:52:59Z<p><span class="autocomment">Creating a Unique Index -</span> typo - replace A with a after New Index point 6</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:52, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 30:</strong></td>
<td colspan="2" align="left"><strong>Line 30:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Index Design}} button on the toolbar. (It looks like a sheet of paper with a blue drafting triangle laying ontop of it.) The {{Window|Indexes}} window opens.</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Index Design}} button on the toolbar. (It looks like a sheet of paper with a blue drafting triangle laying ontop of it.) The {{Window|Indexes}} window opens.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New Index}} icon (a sheet of paper with a yellow sunburst.) </td><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New Index}} icon (a sheet of paper with a yellow sunburst.) </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#'''New Index''' <del style="color: red; font-weight: bold; text-decoration: none;">Appears </del>in the box on the left. Type an appropriate name (e.g. EnglishName)</td><td>+</td><td style="background: #cfc; font-size: smaller;">#'''New Index''' <ins style="color: red; font-weight: bold; text-decoration: none;">appears </ins>in the box on the left. Type an appropriate name (e.g. EnglishName)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Check the {{prefName|unique}} box in the {{Section|Index Details}} section</td><td> </td><td style="background: #eee; font-size: smaller;">#Check the {{prefName|unique}} box in the {{Section|Index Details}} section</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Set the {{prefName|Index Field}} to '''EnglishName''' and the order to '''Ascending'''</td><td> </td><td style="background: #eee; font-size: smaller;">#Set the {{prefName|Index Field}} to '''EnglishName''' and the order to '''Ascending'''</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13636&oldid=prevLJ-Bettona: /* Creating Relationships When One Field is a Primary Key */ typo - remove extraneous the from point 32008-03-29T10:52:14Z<p><span class="autocomment">Creating Relationships When One Field is a Primary Key -</span> typo - remove extraneous the from point 3</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:52, 29 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 9:</strong></td>
<td colspan="2" align="left"><strong>Line 9:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#With the database open, go to the {{menu|Tools}} menu and choose {{menu|Relationships}}</td><td> </td><td style="background: #eee; font-size: smaller;">#With the database open, go to the {{menu|Tools}} menu and choose {{menu|Relationships}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the floating window, click on the '''Field_Trips''' and then click the {{button|Add}} button. A small window named {{window|Field_Trips}} appears in the larger {{window|Relation Design}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#In the floating window, click on the '''Field_Trips''' and then click the {{button|Add}} button. A small window named {{window|Field_Trips}} appears in the larger {{window|Relation Design}} window.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#repeat with <del style="color: red; font-weight: bold; text-decoration: none;">the </del>'''Sightings''' </td><td>+</td><td style="background: #cfc; font-size: smaller;">#repeat with '''Sightings''' </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#click on the the {{prefName|FieldTrip_ID}} field in the {{Window|Field_Trips}} sub-window; drag from there to the {{prefName|Sightings_FieldTrip_ID}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields, with a '''1''' the {{window|Field_Trips}} end and an '''n''' next to the {{Window|Sightings}} window. This identifies a one-to-many relationship.</td><td> </td><td style="background: #eee; font-size: smaller;">#click on the the {{prefName|FieldTrip_ID}} field in the {{Window|Field_Trips}} sub-window; drag from there to the {{prefName|Sightings_FieldTrip_ID}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields, with a '''1''' the {{window|Field_Trips}} end and an '''n''' next to the {{Window|Sightings}} window. This identifies a one-to-many relationship.</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13530&oldid=prevLJ-Bettona: /* Creating a Unique Index */2008-03-13T17:54:12Z<p><span class="autocomment">Creating a Unique Index</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 17:54, 13 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 35:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|Save Index}} icon (a sheet of paper with a "floppy" disk on it).</td><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|Save Index}} icon (a sheet of paper with a "floppy" disk on it).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click {{Button|Close}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Click {{Button|Close}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Close the Table window by clicking on the red button at the top left of the window.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Close the <ins style="color: red; font-weight: bold; text-decoration: none;">{{Window|</ins>Table<ins style="color: red; font-weight: bold; text-decoration: none;">}} </ins>window by clicking on the red button at the top left of the window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Creating a Unique Constraint===</td><td> </td><td style="background: #eee; font-size: smaller;">===Creating a Unique Constraint===</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13526&oldid=prevLJ-Bettona: /* Creating a Unique Index */ add a 'close table window instruction2008-03-13T17:46:05Z<p><span class="autocomment">Creating a Unique Index -</span> add a 'close table window instruction</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 17:46, 13 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 35:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|Save Index}} icon (a sheet of paper with a "floppy" disk on it).</td><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|Save Index}} icon (a sheet of paper with a "floppy" disk on it).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click {{Button|Close}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Click {{Button|Close}}</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#Close the Table window by clicking on the red button at the top left of the window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Creating a Unique Constraint===</td><td> </td><td style="background: #eee; font-size: smaller;">===Creating a Unique Constraint===</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13478&oldid=prevLJ-Bettona: /* Creating Relationships When Neither Field is a Primary Key */2008-03-06T15:51:04Z<p><span class="autocomment">Creating Relationships When Neither Field is a Primary Key</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:51, 6 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 19:</strong></td>
<td colspan="2" align="left"><strong>Line 19:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In the case of our birding database, data entry will be much easier if we do this with two of our relationships, specifically for the relationships between:</td><td> </td><td style="background: #eee; font-size: smaller;">In the case of our birding database, data entry will be much easier if we do this with two of our relationships, specifically for the relationships between:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:The '''AOU_Birdlist''' and '''Sightings''' tables ('''EnglishName''' relates to '''Bird_Name''')</td><td> </td><td style="background: #eee; font-size: smaller;">:The '''AOU_Birdlist''' and '''Sightings''' tables ('''EnglishName''' relates to '''Bird_Name''')</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:The '''Locations''' and '''Field_Trips''' tables ('''<del style="color: red; font-weight: bold; text-decoration: none;">LocationName</del>''' relates to '''Field_Trip_Location''')</td><td>+</td><td style="background: #cfc; font-size: smaller;">:The '''Locations''' and '''Field_Trips''' tables ('''<ins style="color: red; font-weight: bold; text-decoration: none;">Location_Name</ins>''' relates to '''Field_Trip_Location''')</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">The example below follows the procedure for relating the '''AOU_Birdlist''' and '''Sightings''' tables. The same procedure will need to be used to link the '''Locations''' and '''Field_Trips''' tables.</td><td> </td><td style="background: #eee; font-size: smaller;">The example below follows the procedure for relating the '''AOU_Birdlist''' and '''Sightings''' tables. The same procedure will need to be used to link the '''Locations''' and '''Field_Trips''' tables.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td colspan="2" align="left"><strong>Line 27:</strong></td>
<td colspan="2" align="left"><strong>Line 27:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the main database window, click on the {{prefName|Tables}} icon in the left hand column</td><td> </td><td style="background: #eee; font-size: smaller;">#In the main database window, click on the {{prefName|Tables}} icon in the left hand column</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{prefName|AOU_Birdlist}} icon and choose {{Menu|Edit}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{prefName|AOU_Birdlist}} icon and choose {{Menu|Edit}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Click in the cell with the '''<del style="color: red; font-weight: bold; text-decoration: none;">English Name</del>''' field name</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Click in the cell with the '''<ins style="color: red; font-weight: bold; text-decoration: none;">EnglishName</ins>''' field name</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Index Design}} button on the toolbar. (It looks like a sheet of paper with a blue drafting triangle laying ontop of it.) The {{Window|Indexes}} window opens.</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Index Design}} button on the toolbar. (It looks like a sheet of paper with a blue drafting triangle laying ontop of it.) The {{Window|Indexes}} window opens.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New Index}} icon (a sheet of paper with a yellow sunburst.) </td><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New Index}} icon (a sheet of paper with a yellow sunburst.) </td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13477&oldid=prevLJ-Bettona: /* Creating Relationships When One Field is a Primary Key */2008-03-06T15:29:29Z<p><span class="autocomment">Creating Relationships When One Field is a Primary Key</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:29, 6 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 12:</strong></td>
<td colspan="2" align="left"><strong>Line 12:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#click on the the {{prefName|FieldTrip_ID}} field in the {{Window|Field_Trips}} sub-window; drag from there to the {{prefName|Sightings_FieldTrip_ID}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields, with a '''1''' the {{window|Field_Trips}} end and an '''n''' next to the {{Window|Sightings}} window. This identifies a one-to-many relationship.</td><td> </td><td style="background: #eee; font-size: smaller;">#click on the the {{prefName|FieldTrip_ID}} field in the {{Window|Field_Trips}} sub-window; drag from there to the {{prefName|Sightings_FieldTrip_ID}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields, with a '''1''' the {{window|Field_Trips}} end and an '''n''' next to the {{Window|Sightings}} window. This identifies a one-to-many relationship.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#click on the <del style="color: red; font-weight: bold; text-decoration: none;">hard </del>drive symbol in the toolbar to save the changes you have made, and close the window.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#click on the <ins style="color: red; font-weight: bold; text-decoration: none;">disk </ins>drive symbol in the toolbar to save the changes you have made, and close the window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Creating Relationships When Neither Field is a Primary Key==</td><td> </td><td style="background: #eee; font-size: smaller;">==Creating Relationships When Neither Field is a Primary Key==</td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13476&oldid=prevLorinda: correct grammar by adding "to"2008-03-06T15:13:01Z<p>correct grammar by adding "to"</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:13, 6 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{TBBA Header}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Part of the power of Base is that it is a relational database, allowing you to relate different tables of data. In order to make use of this power, we need establish the relationships between the various tables.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Part of the power of Base is that it is a relational database, allowing you to relate different tables of data. In order to make use of this power, we need <ins style="color: red; font-weight: bold; text-decoration: none;">to </ins>establish the relationships between the various tables.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Types of Relationships==</td><td> </td><td style="background: #eee; font-size: smaller;">==Types of Relationships==</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Establishing_Relationships&diff=13473&oldid=prevLJ-Bettona: /* Creating the Relationship */2008-03-06T14:35:55Z<p><span class="autocomment">Creating the Relationship</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:35, 6 March 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 56:</strong></td>
<td colspan="2" align="left"><strong>Line 56:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td><td> </td><td style="background: #eee; font-size: smaller;">#close the floating window</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#click on the the {{prefName|EnglishName}} field in the {{Window|AOU_Birdlist} sub-window; drag from there to the {{prefName|Bird_Name}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields.</td><td> </td><td style="background: #eee; font-size: smaller;">#click on the the {{prefName|EnglishName}} field in the {{Window|AOU_Birdlist} sub-window; drag from there to the {{prefName|Bird_Name}} field in the {{Window|Sightings}} sub-window. A line appears connecting these two fields.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#click on the <del style="color: red; font-weight: bold; text-decoration: none;">hard </del>drive symbol in the toolbar to save the changes you have made, and close the window.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#click on the <ins style="color: red; font-weight: bold; text-decoration: none;">disk </ins>drive symbol in the toolbar to save the changes you have made, and close the window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Related External Links==</td><td> </td><td style="background: #eee; font-size: smaller;">==Related External Links==</td></tr>
</table>LJ-Bettona