You can use the Inspection Tool to update values in the database. For example, to alter the address1 property for a supplier:
You can bulk update objects by selecting the Edit all objects in data bucket option from the Inspector View menu, which opens the Edit Multiple Objects form.
Each option and field on the form is described below. Mandatory options and fields are highlighted in red.
Edit objects in data bucket
Select the data bucket that contains the objects to update.
that are of type
Select that type of object to update. Objects not of this type are not updated.
Change property
Select the property to edit for selected objects.
to
Enter the property's new value.
Close and Edit Objects buttons
Click Edit Objects to perform the update, or Close to close the form without updating.
Note: If any object fails to update, then none of the objects in the data bucket is updated.