Use the * wildcard with other characters to improve your search results. For example, searching on C* returns every candidate record. Likewise, searching on *e returns all position records that include the letter 'e' in the title. After the job application is created, notice that the Reviews related list now appears on the Job Application detail page. That's because we related the Review object to the Job Application object with a master-detail relationship. 2. In the Reviews related list, click New Review to create a review. Do you see how the platform automatically filled in the job application number in the review's edit page? That's one of the small, but important, benefits of using the platform to build an application like this — not only is it easy to create links and relationships between objects, but the platform anticipates what we're doing and helps us accomplish our task with as few clicks as possible. 3. Complete the fields on the review, and click Save . Notice that the name of the candidate and the title of the position appear on the review detail page. If you click the candidate's name, his or her record displays. Go ahead and click around the rest of the app, creating a few more positions, job applications, candidates, and reviews. Pretty neat, huh? Our data is all interconnected, and our edits to the search layouts allow us to view details of several related objects all at once. 121 Expanding the Simple App Using Relationships
Creating a Many-to-Many Relationship Our Recruiting app now has quite a few many-to-one relationships, but what if we needed to create a many-to-many relationship? For example, what if we have an object that stored information about various employment websites, and we wanted to track which open positions we posted to those sites? This would require a many-to-many relationship because: • One position could be posted on many employment websites. • One employment website could list many positions. Here's where we get a little creative. Instead of creating a relationship field on the Position object that directly links to the Employment Website object, we can link them using a junction object . A junction object is a custom object with two master-detail relationships, and is the key to making a many-to-many relationship. For our app, we're going to create a junction object called Job Posting. A job posting fits into the space between positions and employment websites — one position can be posted many times, and one employment website can have many job postings, but a job posting always represents a posting about a single position on a single employment website. In essence, the Job Posting object has a many-to-one relationship with both the Position and the Employment Website objects, and through those many-to-one relationships, we'll have a many-to-many relationship between the Position and Employment Website objects.
You've reached the end of your free preview.
Want to read all 386 pages?
- Winter '17