Hi Steve,

You have it exactly. Terry suggested a dropdown list, which has the correct mechanism, but the list would be too large.

>>
>>If I edit the manager code and save, I would be changing the code for that guy in the manager table, which is not what I want. I want to be able to capture that edit and change the underlying foreign key in the property record.
>>
>
>Jim,
>
>This is where you almost lost me...you aren't talking about editing the Manager code in the Manager Code File Maintenance here, are you? Hopefully you are talking about when the user types in a different manager code when editing a property record.
>
>If you are talking about the latter, you are looking for a mechanism that will have its control source as the proper field in the property record, but will do a lookup in the manager table to make sure that the record exists, and to perhaps set some other default fields in the property records based on this lookup.
>
>Does that sound right?
>
>>I have my own set of subclasses text boxes, etc. I thought I might be able to create one for this purpose. Add a property such as 'underlying_fk' and do some type of value_assign method sophistry to accomplish the task.
>>