Replace field contents of a related tables fields

[AvrioTech]

Right now I have 2 tables

1) Company

2) Employees

Im trying to make script that changes the field "active" to "No" in the company record and in the related employees records when someone trys to delete a record in the company table.

I did a script that says

Replace Field Contients [No dialog; RelCompanyEmployees::Active; "No"]

This sounds like it would work great, but its replacing every single active field (even ones that arent related to the company) to "No".

Both tables are related by the companyID

Im I doing somethign wrong???

Edited October 15, 2006 by Guest

[comment]

Replace Field Contents [] works on all records in the found set. Since it seems you are on a layout of Companies, it does the job for all employees of all found Companies.

You could do it this way:

Freeze Window

Go to Related Record ( Employees ; Show related only ]

Replace Field Contents [ Employees::Active ; "No" ]

Go to Layout [ original layout ]