Page 1 of 1

POPULATE VALUE IN SUBFORM

Posted: Tue Dec 04, 2018 6:28 pm
by sadibou
Hello,
I currently have a subform and I would like to automatically display (like default value) the 'PU' from (temporary Table) in 'Prix Unitaire' as soon as I choose an article by lookup from 'ARTICLE' in (temporary table).
and also check the quantity entered if less than or equal to the quantity in stock (<= 'SOLDE' in temporary table).

I need help :?

I tried with this --> nuSetFormValue('des_prix',nuLookupRecord()->PU); but the field 'Prix Unitaire' still blank

Re: POPULATE VALUE IN SUBFORM

Posted: Wed Dec 05, 2018 9:33 pm
by admin
sadibou,

In the Javascript part of your Lookup you'll need to run

Code: Select all

$('#des_prix').change();

Steven

Re: POPULATE VALUE IN SUBFORM

Posted: Fri Dec 07, 2018 9:06 am
by sadibou
Thank you Steven,

But I think it's the temporary table that does not return information that's why the field is blank.
Is there any other way for me to retrieve the data from the temporary table and use it in the sub form ?

Sadibou

Re: POPULATE VALUE IN SUBFORM

Posted: Sat Dec 08, 2018 12:51 pm
by sadibou
Hi,

It works now. I just had to use the article table in the lookup and recreate the temporary table in the new session.

Sadibou

Re: POPULATE VALUE IN SUBFORM

Posted: Sun Dec 09, 2018 3:05 am
by admin
.