• Sseverson
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Is it prudent to create an object in Salesforce the same way you would create a table for a relational database. See example below. The reason for doing this is so these tables can be controlled by Salesforce users rather than in an inaccessable SQL table, but once the table is setup, no users will have to modify them.

 

 

Grade (table/object) 
GradeIDGradeDesc 
AGreat 
BGood 
CFair 
DBelow Average
EPoor 
   
   
   
ContestGrade (table/object) 
ContestIDGradeIDPointValue
C101A20
C101B10
C101C5
C101D3
C101E0
C102A100
C102B80
C102C50
C102D20
C102E10
C103A5
C103B4
C103C3
C103D2
C103E1