lookup checkbox is not working

mpol_ch · Post by **mpol_ch** » Sun Jan 14, 2024 9:30 pm

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

arbei · Post by **arbei** » Sun Jan 14, 2024 10:42 pm

Avoid using TINYINT(1) with CHECKBOX as lookup, it might be considered as a boolean field. You may use INT instead.

mpol_ch · Post by **mpol_ch** » Mon Jan 15, 2024 12:57 am

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

arbei · Post by **arbei** » Mon Jan 15, 2024 9:15 am

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.

Post by **Webmaster** » Tue Jan 16, 2024 10:19 pm

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.

mpol_ch · Post by **mpol_ch** » Tue Jan 23, 2024 7:12 pm

Hi,
thank you.
It works now with the new release.

mpol_ch