How to Update Key Fields

If you update a key field that validates other tables, you need to change all validated fields that reference that key. For example, if you change the size of BL_ID in the Buildings table, you must change the size of the BL_ID field in the Floors, Rooms, Work Requests, and any other table that is validated by the Buildings table's bl_id field.

Follow this procedure to make this change:

1. In the Smart Client, run System / Add-In Manager / Edit Archibus Field Dictionary , which loads the Archibus Fields table (afm_flds).
2. Restrict this view to show only the fields you want to change. (In this case, you would restrict the view to those records that have BL as a value for Validating Table.)
3. Run the Replace Column command to change the size of the field in all tables that use this field. (In this case you would change the size of the BL_ID field.)
4. Run the Schema Change Wizard to change the actual physical structure of these tables.

Note: If your validating field is named differently than your validated field, you can restrict on the Validating Tables field of the Archibus Fields table. In the Move Orders table, for example, the BL_ID field validates the TO_BL_ID and FROM_BL_ID fields. In this case, you may want to select all fields that depend on the Buildings table, so that the Archibus Fields table displays all the fields that depend on the BL_ID field.