Did you try using workflow rule or process builder? Create a rollup summary field if its a child object on parent to count number of project existing and if rolup field is more than 1 you can trigger WF or Process builder to update field as Inactive.
Thanks,