About Self-Relationships

Not only can you relate one table to another, you can also relate records within a table to each other. This is called a self-relationship. There are lots of situations where self-relationships are useful. If you have a table of names containing many contacts that work for the same company, you can create a self-relationship in a portal to list everyone working for the same company on each individual employee's record. Portal entries can be defined as buttons to switch between records. You can also use a self-relationship to do simple finds, create summary fields, and even create lookups to speed up data entry.