# Foreign Keys Generator

## Faker Configuration

* **Source**: Define the source of the foreign key values. In this example:
  * **Source Type**: Select the type of source (e.g., SQL Table).
  * **Table Name**: Choose the table from which to fetch the foreign key values (e.g., Person).
  * **Value Lookup (Mapping)**: Select the column used for value lookup and mapping (e.g., FirstName).
* **Add Suffix**: Enter any additional suffix to append to the generated data (optional).
* **Replace only if Non-Null**: Check this box to ensure that the faker only replaces non-null values in the column. If unchecked, it will replace all values, including nulls.

<figure><img src="https://3044017923-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBjc0HP8yeHnYIQ2fJ0Ib%2Fuploads%2FxnO63KoCEAlYq4IudU7Y%2Fimage.png?alt=media&#x26;token=18af2cd5-0796-4035-912e-57191f5d8b3a" alt=""><figcaption></figcaption></figure>