Kevin, et al

I have an application which uses locations (addresses) for several business object and I am thinking of creating a location business object.

The table structures have been modified moving the address1, address2, city, state, and ZIP fields to the LOCATION table and replacing them with an iLocationId field.

My problem is if I enter a new location, I need to update the location view and replace the foreign key before saving the main view. Where should I do put this code?

TIA

Rex