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.
-
Go to the Admin area.
-
Click 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.
CAUTION
You won’t be able to go back and create, edit, or delete a Link or Dedupe Field once the custom object is approved. -
Select whether the Link Object is for a lead (person) or a company.
NOTE
If you choose lead, you’ll see Id, email Address, and any custom fields in the list.If you choose company, you’ll see Id and any custom fields in the list. -
Select the Link Field you want to connect to as the parent of the new field.
NOTE
Only string field types are supported in the link field. -
Click Save.
Create a Link Field for a Many-to-Many Structure
Here’s how to create a link field in an intermediary object for use in a many-to-many structure.
-
Go to the Admin area.
-
Click 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.
CAUTION
You won’t be able to go back and create, edit, or delete a Link or Dedupe Field once the custom object is approved. -
Select the Link Object from your database; in this case, Lead.
-
Select the Link Field you want to connect to, in this case, Id.
NOTE
Only string field types are supported in the Link Field. -
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 approved 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.