Self joining relationship
I want the Account object to represent different types like Employee and Employer. Maybe I'll have a Type drop down list that have Employee and Employer values so when you create an Account, you select either Employee or Employer type.
Next I want to establish a one to many relationship like an Employer has 0 - nth number of Employees. So when I go to the Employer layout, then I'll see a list of Employees belonging to that Employer.
But when I go to an Employee layout, I only see one Employer so it's a one to one relationship.
Is this possible?