• Run the script below (by running etrack/programs/etrackconsole.exe, click Maintenance tab and click Run Script)
• Select Tools/Type Settings, select Project on left, click Binoculars next to ‘Place New Item Under’ (that currently has Proposals in it) and in the Find dialog click Cancel.
• Log in as Manager and they can right click on a Division and create a Project (can’t use New button).
• They must then select the Division and the Status. The Division must match the one they right clicked on when project was created, the Status can be anything and the project will automatically be put in the tree under the corresponding project group even if the manager doesn’t have access to it in their tree.

This removes Flags=4 from Allowed Relationships so can create projects. Also removes Flags=16 from Relationship table that also disables new (from relationships but trust me also must be removed)

UPDATE ALLOWEDRELATIONS SET ALLOWEDRELATIONS.Flags = 0
WHERE (((ALLOWEDRELATIONS.ID)=XXX));
UPDATE RELATIONTYPE SET RELATIONTYPE.RelationTypeFlags = 1
WHERE (((RELATIONTYPE.ID)=YYY));
Where xxx is the ID of Division/Project/Project Groups in AllowedRelations table
Where yyy is the ID if Projects/Projects of in Relationshiptable

Posted in: eTrack FAQ, Other