I have created 3 business objects from data extracted from our HR system, the objects are:
1. All staff
In each business object it lists a bunch of fields:
employee number, name, email, position number, position title, classification, team, department, reports to position number.
How do I set up the relationship between these objects to be like the below?
Relationship should be:
All Staff (Reports to position number) = Managers (Position Number)
Managers (Reports to position number) = Directors (Position Number)
When I try and set relationships within the business objects it only gives me 'recid' as a field to choose to create a relationship from. They don;t have the same recid's so this is useless. What am I missing?
I need these relationships to be in place in order to set up some forms and workflows based on management authorisation.