# Displaying data in a form from a different table **URL:** \ **Category:** Ask for Help\ **Created:** [October 12, 2025, 10:25am UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856 "2025-10-12T10:25:52Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![David\_Naughton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_naughton/32/84196_2.png) [@David\_Naughton](https://community.glideapps.com/u/David_Naughton)\ **Post date:** [October 12, 2025, 10:25am UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/1 "2025-10-12T10:25:52Z")
Hi, I’m a newbie to Glide. I have a data table called ‘productions’ and another called ‘allocate tickets’. I have created a form to allocate tickets. What is the best way to pull data from another table? All I want to be able to do is display the contents of a field from the ‘productions’ table in my allocate tickets form. I have tried using a text component, but all I get is this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/b/1bf706f4660e66fedf0243a91726fad9f97ce9de.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 12, 2025, 10:36am UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/2 "2025-10-12T10:36:24Z")
You need to bring the value you need into the current table. The best way to do that depends on your table structure, but it could be as simple as a Single Value column. Can you share screen shots of both tables? ---
**Author:** ![David\_Naughton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_naughton/32/84196_2.png) [@David\_Naughton](https://community.glideapps.com/u/David_Naughton)\ **Post date:** [October 12, 2025, 10:51am UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/3 "2025-10-12T10:51:31Z")
Thanks Darren, The first screenshot is of my productions table, the value that I want to add is the tickets remaining. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/ef26b0c284fa3b73f1252de4ef2afae3e7b8806e.png) The second screenshot is of my allocated tickets table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4530889445c45a872388d2ba32c38d5a8c2d66f.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 12, 2025, 11:12am UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/4 "2025-10-12T11:12:56Z")
Okay. So I assume each row in your Productions table represents a discrete Production? And each row in the same table should link to one of more rows in the Allocated Tickets table? Given the above is correct, what you want is a single relation (or query) from your Allocated Tickets table that matches the correct row in your Productions table, and then use a Lookup through that relation/query to fetch the value you need. It looks like you already have a couple of relations, but I can’t tell if they are correct. I’m also curious about how you are calculating the remaining tickets value? I have a feeling that might not be quite right. ---
**Author:** ![David\_Naughton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_naughton/32/84196_2.png) [@David\_Naughton](https://community.glideapps.com/u/David_Naughton)\ **Post date:** [October 12, 2025, 12:27pm UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/5 "2025-10-12T12:27:44Z")
Hi Darren, Yes, you are correct about the productions table. I have used AI to help me so far! To calculate the tickets remaining, I have a linked productions table and I I’m using a rollup field to calculate the number of tickets allocated from the allocated tickets table and then using a math field to subtract the rollup field from the tickets offered column. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 12, 2025, 2:56pm UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/6 "2025-10-12T14:56:33Z")
> [@David\_Naughton](#): > > To calculate the tickets remaining, I have a linked productions table and I I’m using a rollup field to calculate the number of tickets allocated from the allocated tickets table and then using a math field to subtract the rollup field from the tickets offered column. Okay, that sounds right. Is it giving you the correct result? (difficult to tell from your screen shots). Did the Lookup column work for you to get the value into the Allocated Tickets table? ---
**Author:** ![David\_Naughton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_naughton/32/84196_2.png) [@David\_Naughton](https://community.glideapps.com/u/David_Naughton)\ **Post date:** [October 12, 2025, 7:20pm UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/7 "2025-10-12T19:20:38Z")
Yes, that all worked, but I’m struggling to get that value from the productions data table into the form. I want to be able to display that value so that there are not more tickets allocated than are available ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 13, 2025, 1:50am UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/8 "2025-10-13T01:50:25Z")
Can’t you simply select the value from the 4-dot menu? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/984f090f375e61a8a9eefbce6589589a7a233087.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 13, 2025, 2:05am UTC](https://community.glideapps.com/t/displaying-data-in-a-form-from-a-different-table/84856/9 "2025-10-13T02:05:35Z")
> [@David\_Naughton](#): > > but I’m struggling to get that value from the productions data table into the form. Is the relation a single of multiple relation? (It needs to be single). If your Lookup column returns a value in a “bubble”, that means it’s an array and your relation is a multiple relation.