Page History

When you create custom objects, you must provide link fields to connect the custom object record to the correct parent record.

• For a one-to-many custom structure, use the link field in the custom object to connect it to a person or a company.
• For a many-to-many structure, you use two link fields, connected from a separately created intermediary object (which is a type of custom object, too). One link connects to people or companies in your database and the other connects to the custom object. In this case, the link field is not located in the custom object itself.

Create a Link Field for a One-to-Many Structure

Here's how to create a link field in a custom object for a one-to-many structure.

 Click Admin, and in Database Management, select Marketo Custom Objects.

Select the custom object in the list.

In the Fields tab, click New Field.

Name the link field and add an optional description. Be sure to select the Link data type.

Select whether the link object is for a lead (person) or a company.

Select the link field you want to connect to as the parent of the new field.

Click Save.

Click Admin, and in Database Management, select Marketo Custom Objects.

Select the intermediary object you want to add the field to.

In the Fields tab, click New Field.

You need to create two link fields. Create them one at a time. First, name the field for the members of your database list (leadID, for example). Add an optional description. Be sure to select the link data type.

Select the link object from your database, in this case Lead.

Select the link field you want to connect to, in this case, Id.

Click Save.

Repeat this process for the second link to your custom object, in this example, courseID. The Link Object Name will be course, and the Link Field will be courseID. Since you already created and published the course custom object, these selections are available in the drop-down menus.

Create any other fields that you want to use in your intermediary object, such as enrollmentID or grade.

Using Custom Objects

The next step is to use these custom objects in filters in your smart campaigns. With a many-to-many relationship, you can select multiple people/companies and multiple custom objects. In the example below, anyone in your database who matches these criteria will be listed. The coursename field comes from the course custom object and the enrollment grade comes from the intermediate object.