|
Trying to understand...
Each Item in the OrgTree is a Position in the Organization.
From a completed OrgPosition Item, place the cursor in the OrgEmployee field (contains data from Info Item Lookup) and do a Ctrl-Q to jump to the Employee Item - if you don't leave the Employee Item won't the Back button return you from where you started.
But what if you start at an Employee Item and want to know its OrgPosition(s).
A saved Search Item as the child of the Employee - Kinook's suggestion:
(OrgEmployee) equals (choose from Lookup)
This assumes that the OrgEmployee Attribute is only used in one location (OrgTree).
Otherwise, you've got to have an OrgPosition Info Item in the Employee record - but what if an Employee is working on more than one Product (occupies more than one position in the OrgTree - is this possible?). Or what if the Employee moves to another Product (changing Poisition in the OrgTree), you have to come back and "touch" the Employee record to reflect the change.
Is the OrgTree an Intersection table between Employees and Products (Parts)?
|