Re: Set Field in other instances on a new instance

Home Forum General Set Field in other instances on a new instance Re: Set Field in other instances on a new instance

#6393

Peanuts890
Participant

Hi Dennis, yes there is a reason and I probably didn’t explain things very well.

I use a Reference form which will only ever have one instance. This reference form contains a number of dropdown boxes populated by data taken from other external sources. The thinking here is two-fold, firstly since the form has to be updated and published every time a dropdown box contents are changed, it keeps the number of version changes limited to this one reference form. Secondly I assume adding a couple of dropdown boxes to forms (like my invoice approval form) increases the size of the form.

On this basis I decided to use this approach. For example on a new instance of the invoice approval form, when I get to entering the supplier’s name, I wanted to access the reference form, find the supplier from a dropdown box and return the data to the invoice approval form. The invoice form will remain open until all the data is entered.

As I tried to explain earlier, I use a lookup button which opens the reference form and once a supplier is selected I am trying to close the reference form and return the selected data back to the invoice form. I was trying to use a “set field in other instance” command but that doesn’t seem to work.

Your help is appreciated – can I just add that the invoice approval form is only one of many forms that will access the reference form dropdown boxes.

Regards.

Do NOT follow this link or you will be banned from the site!