Hierarchic relation between CustomObjects - PK , Foreign Key

[Anonymous]

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

[Josh_Hill13]

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]

Thanks for your response.

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

-Mahesh