Display checkbox when the item is loaded based on another collection in another form

Legacy Contributor

Hello All,

 

I have two checkboxes each setup on two different forms(customer orders and customer contracts). I am trying to setup the checkbox in the customer orders to auto populate the check mark based on the values from the customer contracts form. I am not sure how to link it. I have added the primary collection of customer contracts as secondary collection to the customer orders form but not sure if thats the right way to go about it. Any help is much appreciated.

 

Thanks,

john-bourke

Have you tried creating / adding a form script, and then calling it as an event action as part of the Form open event?



Roughly speaking, the basic event would be something akin to this:



'The first DIM defines a variable to hold the collection / values returned, so it's defined as "LoadCollectionResponseData"

DIM [a variable] as LoadCollectionResponseData



'The second DIM defines a variable that will be used as a filter when loading the collection we need to check

DIM [another variable] as String = [Build your string, including any values from existing form entries you might need]



'Below, the "a variable" you defined above is loaded with the collection data you need to cross-reference/use; the "another variable" is used to filter the collection.

[a variable] = IDOClient.Loadcollection("TheCollectionYouNeed", New PropertyList("[property name in the collection you need to return or test]", [another variable], String.Empty, 1)



'This next line then assigns the loaded variable to a form field, using the returned value from the collection in String format

ThisForm.Components("[Form field name]").Value = [a variable](0,"[property name]").String



You could do other things like simply check the condition of the returned value and turn a checkbox on or off.

0712131256598360.doc