# Retrieving non linked field

**URL:** <https://community.noloco.io/t/retrieving-non-linked-field/490>\
**Category:** Ask for Help\
**Created:** [April 3, 2024, 3:50pm UTC](https://community.noloco.io/t/retrieving-non-linked-field/490 "2024-04-03T15:50:32Z")\
**Posts on this page:** 2\
**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:** [April 3, 2024, 3:50pm UTC](https://community.noloco.io/t/retrieving-non-linked-field/490/1 "2024-04-03T15:50:32Z")

</div>

Hello, I’m trying to reduce the number of queries I’m using and wondered if anyone had a scenario like mine they could help with.

I have 2 tables, clients & leads linked by the client\_id, so when a lead is added to the client, the client\_id also gets inserted into the leads table. All good so far.

I now need to display all leads but also have the client name from the clients table added. I’ve done this via a query so far, but its not ideal as there are 23000+ records and it then becomes uneditable.

Is there any method to pulling/linking the client name into the leads table when adding a new lead to that client, so Id have client\_id (1017) & client\_name (gary brett) added to the lead record.

I’m using mysql by the way.

Thank you

---

<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 3, 2024, 9:35pm UTC](https://community.noloco.io/t/retrieving-non-linked-field/490/2 "2024-04-03T21:35:53Z")

</div>

I wonder if this is a possibility? Instead of the default add new record button, could I create a custom button with a URL maybe to do the same which inserts the client\_name into a field?

So, client collection at the top with client record. Linked leads collection below for ‘Add New Lead To Client’.

Could I then somehow pre populate the client\_name (and any other details I may need.

Click ~ mymodal/#clientname#clientemail for example?
