---
updatedAt: 2025-09-22T23:30:01.000Z
agentTools:
projectIndex: https://docs.budibase.com/llms.txt
---
# Link two entities in one form
Example: Creating an employee record and linking them to a newly created job
## Try it out!
{`
`}
## Scenario
When creating a new job, you want the option of creating and linking a new employee to that job in the one form. For this example you should use the sample data supplied in the internal BudibaseDB tables.
{`
Challenge: ★★★★☆
`}
***
## Steps
1. `Add component`: **Form Block**
2. In the Settings Panel, select the 'Jobs' *Table*
3. At the very bottom of the settings panel, click `Eject` - this will break down the Form Block into it's constituent parts. We can see this in the component tree.
4. `Add component`: **Options Picker**
5. In the Settings Panel, enter 'ExistingEmployee' as the *Field*.
6.
7. Set *Type* to 'Radio buttons'
8. Set *Direction* to 'Horizontal'
9. Set *Default value* to 'SELECT'
10. Uncheck *Alphabetical*
11. Set *Options source* to 'Custom'
12. `Define options`:
1. | Label | Value |
| :----------------------- | :----- |
| Select existing employee | SELECT |
| Create new employee | NEW |
13. In the component tree, drag the **Relationshipfield** below the **Options Picker**
14. Click on the `Conditions` tab
15. `Configure conditions`: `Add condition`
1. Hide component IF `{{ Form.Fields.ExistingEmployee }}` Equals Binding NEW
2. `Save`
16. `Add component`: **Container**
17. Click on the `Conditions` tab
18. `Configure conditions`: `Add condition`
1. Hide component IF `{{ Form.Fields.ExistingEmployee }}` Equals Binding SELECT
2. `Save`
19. `Add component`: **Headline**. Set *Text* to 'New Employee'
20. `Add component`: **Field Group**
21. Click on the **Form** and set the *Schema* to 'Employees'
22. Click on the newly added **Field Group** and click `Update form fields`
23. Set *Type* to `Two columns`
24. [Delete](https://docs.budibase.com/docs/components#editing) the **Jobs** field
25. You may also need to replace the *Text Field* for Address with a *Long Form Field* if it displays as an error.
26. Click on the **Form** and set the *Schema* back to 'Jobs'
27. Click on the 'Save' **Button**, enter the settings using the cog-icon and `Define actions`
28. Click the `X` beside each actions so that only the **Validate Form** and **Save Row** actions remain
29. `Add Action`: **Navigate To** *Screen* '/jobs'
30. `Add Action`: **Continue if / Stop if**
1. Continue if `{{ Form.Fields.ExistingEmployee }}` Equals NEW
31. `Add Action`: **Save Row**
1. Set *Table* to 'Employees'
2. `Add Column` for each form field in the Employees **Field Group**. Set the *Value* to the form field bindings, e.g. `{{ Form.Fields.First Name }}`
3. `Add Column` for the 'Jobs' column. Set *Value* to `{{ Action 2.Saved row._id }}`. This will get the **\_id** of the Job that was saved in second action.
4. `Save` your actions!
> 📘 Employee validation
>
> As the select form schema is for the *Jobs* table, you will need to add [custom validation rules](https://docs.budibase.com/docs/form-validation#custom-validation-rules) to the *Employee* fields you want validated.
>
> The same is also true for options that are defined by the table schema, such as *Employee Level* in this case.
***
## App export
*Downloads may take a few seconds.*
{`
`}