Page 1 of 1
lookup checkbox is not working
Posted: Sun Jan 14, 2024 9:30 pm
by mpol_ch
Hi,
I am using a lookup check with the following setting (v2024.6.0), which is not working.
Lookup: Select
Link field: Status (Tiny INT)
Display fields #1: Beschreibung (Varchar)
Result is "1" and not "New" ..
mpol_ch
Re: lookup checkbox is not working
Posted: Sun Jan 14, 2024 10:42 pm
by arbei
Avoid using TINYINT(1) with CHECKBOX as lookup, it might be considered as a boolean field. You may use INT instead.
Re: lookup checkbox is not working
Posted: Mon Jan 15, 2024 12:57 am
by mpol_ch
Hi,
I just changed the type from TinyInt into Int(3).
I did the change on both tables.
But the result is the same.
mpol_ch
Re: lookup checkbox is not working
Posted: Mon Jan 15, 2024 9:15 am
by arbei
You may post your table schema of the main table and the lookup table, and the Edit Tag and Lookup Table settings for other uses to reproduce.
Re: lookup checkbox is not working
Posted: Tue Jan 16, 2024 10:19 pm
by Webmaster
Try v2024.7.0. If it does not work, and you are a registered users of v2024, you should send your files and required info to support.
Re: lookup checkbox is not working
Posted: Tue Jan 23, 2024 7:12 pm
by mpol_ch
Hi,
thank you.
It works now with the new release.
mpol_ch