# Mysql 1 form into 2 collection tables

**URL:** <https://community.noloco.io/t/mysql-1-form-into-2-collection-tables/435>\
**Category:** Ask for Help\
**Created:** [March 23, 2024, 9:03am UTC](https://community.noloco.io/t/mysql-1-form-into-2-collection-tables/435 "2024-03-23T09:03:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [March 23, 2024, 9:03am UTC](https://community.noloco.io/t/mysql-1-form-into-2-collection-tables/435/1 "2024-03-23T09:03:13Z")

</div>

Hello, anyone know if it’s possible to insert data from 1 form into 2 tables?

I have clients and leads tables linked by client\_id. When staff add a client into the front end id like the same form to collect lead details too.

So in save, client\_id is created in clients table, then into leads table linking the records.

Not sure if there is such a thing as a two step form in Noloco, first page is client details, click next (creates client\_id) and loads the second page with connected lead details.

Thank you

---

<div class="post-metadata">

**Author:** ![Ben](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/ben/32/26_2.png) [@Ben](https://community.noloco.io/u/Ben)\
**Post date:** [March 23, 2024, 6:56pm UTC](https://community.noloco.io/t/mysql-1-form-into-2-collection-tables/435/2 "2024-03-23T18:56:26Z")

</div>

You could use the OnSave Action if you’re on the Pro plan or higher. You’d likely want to use a URL that you construct to pass a value to filter the client in the leads table.  
Alternatively you could use a workflow to copy the data over to the leads table once a client record is created.

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [April 6, 2024, 8:04pm UTC](https://community.noloco.io/t/mysql-1-form-into-2-collection-tables/435/3 "2024-04-06T20:04:04Z")

</div>

Thanks @Ben, I am on the Pro plan and hadn’t come across the on save action, I’ll see if I can locate where that is, it may be just what I need.