Microsoft KB Archive/175783

= FP98: Database Column Values Inserted Into Same Table Cell =

Article ID: 175783

Article Last Modified on 12/1/2000

-

APPLIES TO


 * Microsoft FrontPage 98 Standard Edition

-



This article was previously published under Q175783



SYMPTOMS
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.



CAUSE
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.



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



WORKAROUND
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.
 * 7) 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.

