ContributionsMost RecentMost LikesSolutionsRe: Related table value with conditional dropdown gets set to 0 We've made a few changes to our pipelines and have turned off our action items (for a short period). We will monitor and see. Thank you. ------------------------------ Uma Harithsa ------------------------------ Re: Related table value with conditional dropdown gets set to 0 The users of this database select the values for that field. ------------------------------ Uma Harithsa ------------------------------ Re: Related table value with conditional dropdown gets set to 0 Hi Chayce, no form rule. And these are set with specific values and then they get set to 0 randomly. Thanks, Uma ------------------------------ Uma Harithsa ------------------------------ Re: Related table value with conditional dropdown gets set to 0 Hello Marcelo. I did and nada. Thanks, Uma ------------------------------ Uma Harithsa ------------------------------ Related table value with conditional dropdown gets set to 0 Background: Workstation Hardware (child) and Tracking Board Master (parent) are related with a conditional choice. Please see screenshot below. Issue: We are running into this issue where repeatedly the related table field on many rows is getting set to 0. It seems QuickBase Actions or Pipelines are changing this. But there is no pipeline or QB action that is changing the selection in for the dependent Related field to be nulled. Nor are any of the actions or pipelines changing the Related Tracking Board Master field itself. This one is really stumping us. We have multiple such relationships built in our database, but none of them are behaving this way. Seems like a bug. Any suggestions on how to debug this further? Thanks a lot. Uma ------------------------------ Uma Harithsa Trinity Health ------------------------------ Separate out multiselect text field items in a summary report Hello. I have a multiselect text field 'Construction Plan - ASMT' with 6 values. I need to create a summary report to count the Construction Plan and the status it is in. Screen shot below. Without creating a child table for this field, can i create a summary report where the textlist field items are separated out? Today we are doing this in Access. Thank you. ------------------------------ Uma Harithsa ------------------------------ Re: View grandchild records in formLaura. Thank you for your help. It worked!! ------------------------------ Uma Harithsa ------------------------------ View grandchild records in formI have 3 tables: Assessment, Locations and Workstations. Assessment connects to one or many Locations; A location has many workstations. I would like to display the grandchild (workstation table) records in the Assessment form? Is this possible without making a relationship between assessment and workstation table? I am afraid that making a triangle relationship may result in mismatched data (if workstations are moved from one location to another). Please advise. Thanks. ------------------------------ Uma Harithsa ------------------------------ SolvedRe: Count Table of Display sizes by LocationWas able to follow along until copying summary report data to another Table. I am confused with steps after that. Which table should the [exists?] field be created in - details table or new table? How do I check if that data exists in the new table?Re: Count Table of Display sizes by Location Thank You very much. I will try this.