If the fields that have been added to a table need to be changed, you can do this in the Database Map Editor window.
You can add a field to a table of any level (client, practice and master). Fields added will belong to the level at which they were added. For example, if you add a field at the client level, you will not see that field if you open Report Designer at the practice level, even if it was a practice level table you added it to.
To edit a field in a table within Report Designer (on the Database Map tab)
Open the Database Map Editor window for the table you want to edit fields for.
To add a new field, select the Add New Field button . The cursor will be placed in the Name field ready for you to start defining the new field. See Adding a field to a Database Map table.
If you want to delete a field from the table:
Select the field in the Table Definition area of the window
Click the Delete button . A message will be displayed asking you to confirm your actions.
Click Yes to confirm the deletion.
If there is only one field in a table the Delete button will be disabled.
If you want to edit a field:
Select it in the Table Definition area of the window or double click it in the tree list in the Explorer pane.
Make the changes required to the Name, Type, Description and Default settings.