I have a table with two columns. One column is a role and the other are keywords associated with that role. For example:

Roles Keywords
Admin Desk, Forms, Data Entry
HR People, Communication

What is the best way to store this data in custom metadata types in Salesforce?

1 Answer 1


You can create a metadata relationship.

Keep Role metadata as parent. And RoleChild as a child relationship metadata.

Just like a parent child relationship. So when you see admin, it will display all RoleChild under it.

enter image description here

  • Thanks, that is exactly what I was looking for. And would it be the case of creating a new record for each keyword or is there a way to have a sort of picklist of each set of values?
    – eHarazi
    Commented Jun 21, 2023 at 12:27
  • I didnt understand the ask in your comment. Commented Jun 21, 2023 at 12:54
  • It's okay. Each keyword will need its own record and linked to the parent record for the role. Thanks
    – eHarazi
    Commented Jun 21, 2023 at 17:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .