# How to get the Row ID from another table with a specific status during form submission **URL:** \ **Category:** Ask for Help\ **Created:** [December 20, 2023, 5:30pm UTC](https://community.glideapps.com/t/how-to-get-the-row-id-from-another-table-with-a-specific-status-during-form-submission/68889 "2023-12-20T17:30:24Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![dannn](https://avatars.discourse-cdn.com/v4/letter/d/b5a626/32.png) [@dannn](https://community.glideapps.com/u/dannn)\ **Post date:** [December 20, 2023, 5:30pm UTC](https://community.glideapps.com/t/how-to-get-the-row-id-from-another-table-with-a-specific-status-during-form-submission/68889/1 "2023-12-20T17:30:24Z")
Hi all! New user here. I’m trying to build a simple app to place orders from available inventory. I have 3 tables: 1. Inventory, 2. Order Release 3. Order Release Log (shows what’s ordered for each order release). I currently have a button that creates an “In Progress” Order Release with a unique row ID. There will only be 1 “In Progress” at any time ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6ab546d00528fe0a4c14e80842eb7991d9e1d28.png) Then, within each product page, I have a form adding new rows to the Order Release Log table. I’d like to get the Row ID of the ‘In Progress’ order in the other table so I can ultimately connect them with relations. BUT I have no idea how to get anything from the other table within the form that’s provided. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f37af4d3d8f283369b8f4a111d5ab93c7cdddce.jpeg) I could add new rows now with the item and quantity to order in the Order Release Log, but no idea how to connect it to the “In Progress” order release without getting that Row ID during that form submission. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/67ac8dc8bd7ce2c63e3ac7a180c5c80fc7107175.png) Thanks! ---
**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:** [December 20, 2023, 7:18pm UTC](https://community.glideapps.com/t/how-to-get-the-row-id-from-another-table-with-a-specific-status-during-form-submission/68889/2 "2023-12-20T19:18:47Z")
Is the row ID of the order not available when clicking here? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d65e465fea906934d3d2bf2628b7ad9af7ba6823.png) ---
**Author:** ![dannn](https://avatars.discourse-cdn.com/v4/letter/d/b5a626/32.png) [@dannn](https://community.glideapps.com/u/dannn)\ **Post date:** [December 20, 2023, 9:18pm UTC](https://community.glideapps.com/t/how-to-get-the-row-id-from-another-table-with-a-specific-status-during-form-submission/68889/3 "2023-12-20T21:18:44Z")
No since it only shows me options in the “Order Release Log” table, but I wanted to get the Order ID of the In Progress order in the “Order Release” table. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/162860268c772ab4b6ae9d344625acc262c5721d.png) ---
**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:** [December 20, 2023, 9:32pm UTC](https://community.glideapps.com/t/how-to-get-the-row-id-from-another-table-with-a-specific-status-during-form-submission/68889/4 "2023-12-20T21:32:23Z")
It appears as though you’re building out the log form from within the Inventory table, but I think the form should really be built within the newly created order release table so you can access the order release fields/values.