Inserting Data from the Data Source View into a Writer Document

From NeoWiki

Revision as of 00:38, 14 November 2007 by Lorinda (Talk | contribs)
Jump to: navigation, search
This article is part of the To Base and Back Again tutorial series.

Contents

Inserting Fields from the Data Source


Adding Fields in the flow of your document

  1. In a new or exisitng Writer document, open the Data Source View (from the View menu, choose Data Sources
  2. Select the data source and table or query you want to work with
  3. Filter and/or Sort the information as desired.
  4. Drag the field name from the column headers in the table area of the Data Source View to the location in your document where you want it to appear. A field name encased in < > will appear in you document.
    If you have FIeld Names checked in the View Menu you will not see < or > and you will see a field name like BirdDatabase.FieldTrips.Location where the patternis DatabaseFileName.TableOrQueryName.FieldName.
    If you have Field Shadings turned on the the View menu, the field names will appear with grey highlighting.
  5. Repeat as often as needed until you have the fields you need in your document.
  6. To see a sample of data in your document:
    1. Make sure that a row of data is selected in the data table of the Data Source View. Do this by clicking in the grey box to the left of the desired row of data.
    2. Click on the Data To Fields button on the Table Data Toolbar.


Quickly Creating a Writer Table


Using the Next Record Field


Issues with Image Fields

Creating Forms in Writer Documents

Forms are not limited to those stored within an odb file. You can also create a form in an "independent" or "external" Writer document. When working with forms, you do not use the Data Source View.

  1. Make Sure that the Form Controls and Form Design toolbars are visible. If they are not, go to the View menu, choose Toolbars and select the needed toolbars.
  2. Click on the Form button. The Form Properties window should appear.
    You can also reach the Form Properties window by clicking on the Form Navigator button, control-clicking on the name of the form (most likely Standard), and choosiing Properties.
  3. Click on the Data tab.
  4. Click on the ... next to Data Sources and browse to locate the desired data source
  5. Set the Content type for Table or Query, depending on your source. Those familiar with SQL can also choose SQL Command
  6. Select the desired Query or Table from the Content drop-down
  7. Adjust other settings as desired, and close the Form Properties window.

From this point on, editing forms in an independent Writer document should work the same way editing forms stored in he odb file do.

Personal tools