Thank you for taking the time to read my question.
I have a parent gallery with a nested horizontal gallery. The horizontal gallery has check boxes in it. The items for the horizontal gallery is a collection of 4 values. On Check adds a value to a different collection (colPrimaryFeedType), On Uncheck removes it from the collection (colPrimaryFeedType)
I then save the collection to a SQL table.
After I save the data to SQL, because the Items for the horizonal gallery is not the data selected, all the check boxes become unchecked. Therefore I'm using the following Lookup to try and "recheck" the check boxes so the user won't think the data was erased instead of saved. What I'm getting is that only one check box per parent gallery record is being checked instead of all instances.
If(LookUp(colPrimaryFeedType,Value(tBinID) = Value(lblBinID.Text)).tFeedType = ThisItem.FeedType,true,false)
//LookUp(colPrimaryFeedType,Value(tBinID) = Value(lblBinID.Text),true)
If the user selects Starter and Grower for Barn 1, Bin 1 and then saves, only Starter is checked with the uncommented formula above. I also tried the commented out formula, but everything is checked, even when adding records to colPrimaryFeedType.
How do I get all the right check boxes checked?
Thanks
