Re: Hierarchic relation between CustomObjects - PK , Foreign Key

Anonymous
Not applicable

Hierarchic relation between CustomObjects - PK , Foreign Key

Hi,

I am curious to know if I can create a Primary Key - foreign Key relation to the properties of Custom Objects ?

Eg : Say I have Custom Objs

  • Course - CourseId,Title,
  • Student - StudID, Name, DOB,
  • Enrollment -  EnrollD , CourseID, StudId , deadlineDt, Grade , PaymentDt ,
  • Payment - PayId, StudId, EnrollD

I am not sure yet, this structure may be an overkill ... none the less If I don't want to post data to Payment without an entry in Enrollment for the student - (StudID,EnrollId - dedupeBy) . From what I understand so far ... as long as there is no unique record combo in a custom object data is accepted and 'created'. 

Can we add a constraint to this entry.. since this has to be a valid in the other custom object as well ?

Appreciate your help.

- Mahesh

2 REPLIES 2
Josh_Hill13
Level 10 - Champion Alumni

Re: Hierarchic relation between CustomObjects - PK , Foreign Key

I'd read the docs carefully. They discuss the Student-Course issue.

I'm not entirely sure you can just create a whole DB like you suggest though, but maybe you can. It might be better to build a db properly outside of Marketo and then use the API to populate the data. This might work best in SFDC given how you can pull those custom objects in.

Anonymous
Not applicable

Re: Hierarchic relation between CustomObjects - PK , Foreign Key

Thanks for your response.

Apparently this may not work - we will go with a different approach to 'fit into' Marketo way.

-Mahesh