Page 1 of 1
lookup with select '#browse_filter#'
Posted: Mon Oct 15, 2012 12:34 pm
by 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
Re: lookup with select '#browse_filter#'
Posted: Thu Oct 18, 2012 4:14 am
by admin
johan,
Sorry, I don't understand what you mean.
Steven
Re: lookup with select '#browse_filter#'
Posted: Thu Oct 18, 2012 9:35 am
by 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
Hope this explaines my question.
Johan
Re: lookup with select '#browse_filter#'
Posted: Fri Oct 19, 2012 1:11 am
by 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):
img.png
This don't fix the problem, but maybe can be a temporary solution.
Max
Re: lookup with select '#browse_filter#'
Posted: Fri Oct 19, 2012 8:58 am
by 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
Re: lookup with select '#browse_filter#'
Posted: Mon Oct 22, 2012 5:55 am
by 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
Re: lookup with select '#browse_filter#'
Posted: Tue Oct 23, 2012 8:49 am
by johan
Steven,
Works fine, thanks
Johan
Re: lookup with select '#browse_filter#'
Posted: Wed Oct 24, 2012 4:15 am
by admin
.