# Using Composite Keys

This snippet sample project demonstrates how to configure composite keys for updating and deleting records.

{% hint style="info" %}
The sample uses a simple example for deleting a record from a SQL Customers table using multiple fields that make up the composite key.   The process is the same for modifying a record using composite keys.
{% endhint %}

<figure><img src="https://1923141441-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFjmFrZ8sef1J7qkr6H%2Fuploads%2FJ8AwkoLAhlBBWtYB0meZ%2Fimage.png?alt=media&#x26;token=e7daa6c8-a348-444b-98fc-40c1fa2267ec" alt=""><figcaption></figcaption></figure>

**Activities:**

1. **InitializeTarget**   This activity initializes the Target activity that will be used for the deletion.
2. **DeleteRecord**  This activity is used for performing the actual record deletion.

&#x20;  Edit the DeleteRecord activity:

&#x20;

<figure><img src="https://1923141441-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFjmFrZ8sef1J7qkr6H%2Fuploads%2FdXS3Wrs8UPT4huXuV8Wa%2Fimage.png?alt=media&#x26;token=993e3702-75d6-438d-ac4f-14d1908f83d5" alt=""><figcaption></figcaption></figure>

Then click on the Option property:

<figure><img src="https://1923141441-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFjmFrZ8sef1J7qkr6H%2Fuploads%2FmVP4ngmEljrtyHyZMTC2%2Fimage.png?alt=media&#x26;token=47d5f75f-778d-49b1-8bf5-5f0ea89cb87e" alt=""><figcaption></figcaption></figure>

Select Composite Key as the key type and configure the collection of composite keys:

<figure><img src="https://1923141441-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MFjmFrZ8sef1J7qkr6H%2Fuploads%2FhPDcaku5tSnVP42zl3tI%2Fimage.png?alt=media&#x26;token=294e21d8-6826-44ca-8e41-c880bb8bc086" alt=""><figcaption></figcaption></figure>
