lookup with select '#browse_filter#'

[johan]

Hi,

I'm using a lookup on a subform with Default SQL select '#browse_filter#'. This is a great improvement.

Only thing not working is the update of other fields with the lookup. (before I added select '#browse_filter#' the other fields where updated so that part was working)

Johan

[admin]

johan,

Sorry, I don't understand what you mean.

Steven

[johan]

Steven,

I've added a browse screen in edit form as discribed in http://www.youtube.com/watch?v=6d_nYErMGPI.

The browse_filter works fine.
In my lookup I have some fields to update but that part does'nt work when I' m using select '#browse_filter#'. Without browse_filter the update of other fields works fine.

lookup.png (8.41 KiB) Viewed 4929 times

Hope this explaines my question.
Johan

[massiws]

Johan,

you are right.
I find a workaround using display objects on second form and few lines of JavaScript to change them to what I need (a textarea in this example):

Update other fields in a form with #browse_filter# in a lookup object

img.png (85.76 KiB) Viewed 4924 times

This don't fix the problem, but maybe can be a temporary solution.

Max

[johan]

Max,

Thanks for your reply. That's a possibility.

I started from an existing form where I have some hidden text fields to be updated with the lookup. In that case (for me) display is not the correct option.

Johan

[admin]

Johan,

Populating extra fields will be done if you change the lookup manually and that's the only way it has ever worked..

But, you can fake this manual change on nuLoadThis()

Code: Select all

function nuLoadThis() {

   if($('#recordID').val() == '-1'){
      $('#codetra_customer_id').change();
   }

}

(codetra_customer_id) is the code part of the lookup.

I hope this makes sense.

Steven

[johan]

Steven,

Works fine, thanks

Johan

[admin]

.