A message box prompts you to confirm the deletion of the field or fields. If any tables in the data map contain columns that are based on the field or fields, the message box notifies you that the deletion of the field or fields also deletes any columns that cross-reference the field or fields.
To view which columns in which tables cross-reference the field or fields, click
More Details
. In the
References affected by current delete
list, the icons for the items that PowerExchange will delete when it deletes the field or fields appear in gray.
In the message box that prompts you to confirm the deletion, click
Yes
.
PowerExchange deletes the field or fields from the record. If you delete all fields from a record, PowerExchange does not delete the record.
If any columns in tables were based on the field or fields, PowerExchange deletes those columns from the tables. If you delete all fields from a record on which all columns in a table are based, PowerExchange deletes all the columns in the table but does not delete the table.