Updating records
Now, let's fill in some data in our newly created fields and relationships:
- Update the Director field to Francis Ford Coppola; you'll notice that we haven't created a record for Francis Ford Coppola in the Person table yet, but you can do that directly while updating the movie record's director lookup. Just click the New Person choice and fill in the following details:
- Person Name: Francis Ford Coppola.
- Biography: Here comes the biography of Francis Ford Coppola.
- Birthdate: April 7th, 1939.
- Click on Save.
- Now, you should have a clickable link to the Francis Ford Coppola person on the movie record of The Godfather:
- Now, if you click on the Francis Ford Coppola relation, you'll find yourself on its Person record page layout. This seems OK, but check the Related tab; here, we see only the Cast related list and not the Movies related list for which Francis Ford Coppola is the director. I'm not going to re-explain how to adapt the page layout, since we just did that, but go ahead and modify the page layout and add the related list Movies to the Person page layout and make sure that Movie Title, Genre, Release date, and Runtime are visible as columns. The result should look like this:
- OK, great work! Now, let's go back to our movie record, The Godfather, and add two production companies in the Production Companies related list.
- Click New in the related list and search for Paramount Pictures (which we already have as a record in the Company table).
- Add a second production company, but now click the New button to create a new company record at once for Alfran Productions with the address, 1125 Gayley Ave Los Angeles, CA 90024. Now, the result should look like the following screenshot:
This is really starting to make sense now. Our BIM DB app is coming to life and we are able to create movies, people, companies, and reviews, linking them and automatically having complete overviews from every angle.
Until now, we have been creating single records manually to test out our app and build it out. It seems that our foundational structure and data model is almost ready to fill our BIM DB with loads of movies, actors and actresses, directors, production companies, and reviews. But, it would be a very tedious work to create those records one by one. Don't worry, we won't be doing that. Luckily for us, in the next section we'll see and learn the different ways we can import data into our Salesforce environment in bulk. So, let's get on with it.