FP98: Database Column Values Inserted Into Same Table Cell

When you attempt to insert a database column value into a database table, the database column value is inserted into the current cell rather than a new cell in the table.

This behavior occurs if you select the "Show the query in a table " check box while you are creating the database table by using the Database Region Wizard. Once the Wizard inserts the table, you cannot add or remove column values.

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

To work around this problem, follow these steps:

1. Insert a new table cell into the database table. To do this,
   
   
   1. Click in any database column so that the Column Value command will be available when you point to Database on the Insert menu.
   2. On the Table menu, click "Insert Rows or Columns."
   3. In the "Insert Rows or Columns" dialog box, click Columns.
   4. In the Number Of Columns box, type 1 or click the arrows to select one column.
   5. Click either Left Of Selection or Right Of Selection.
   6. Click OK.
2. Insert a database column value into the new table cell:
   
   
   1. Click in the cell you created in step 1.
   2. On the Insert menu, point to Database, and click Column Value.
   3. In the Database Column Value dialog box, type a query field name or select one from the list box.
   4. Click OK.

For more information about database column values, click the Index tab in FrontPage Help, type the following text and then double-click the selected text to go to the "Database Column Value command" topic.