Page 1 of 1
Subform lookup NULL on first row only
Posted: Tue Mar 08, 2022 8:15 am
by vario
I have a subform with a lookup field. When I enter several rows and do not have a value in the lookup, only the first is created with a NULL column value and the rest are empty strings. I would prefer it to leave the unpopulated column values as NULL. I'm using the latest version (from Sourceforge).
Neil.
Re: Subform lookup NULL on first row only
Posted: Wed Mar 09, 2022 8:07 am
by kev1n
Try replacing
this line
Code: Select all
$("[id^='" + o.form + nuPad3(o.rows) + "']").addClass('nuEdited')
with
Code: Select all
$("[id^='" + o.form + nuPad3(o.rows) + "']").removeClass('nuEdited')
then log in again.
Re: Subform lookup NULL on first row only
Posted: Wed Mar 09, 2022 2:17 pm
by vario
Thanks! NULL values in all unpopulated lookup ids.
Neil.
Re: Subform lookup NULL on first row only
Posted: Wed Mar 23, 2022 5:44 pm
by kev1n
This is now on Github.