set checked default for dynamic checkbox

PHPMaker General Discussion (PHPMaker)
1

I have a table:
job_table
job_id
exployed_id
name_job
lookup tabel: employee_table
Link field: employee_id
name field: employee_name
edit tag: checkbox

in add_page of job_table how to show all employee with checked default to all checkbox(it show all unchecked default)?

thanks so much!

2

If you use MySQL, you may try to set the default value of the lookup field (assume VARCHAR type) as:

ExecuteScalar(“SELECT GROUP_CONCAT(employee_id) FROM employee_table”)

Note there is a limit in length, see: https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_group-concat.

3

wow, that’s great! thank you.

now, I would like to do the same with:
when i select trademake, it would show all model(dynamic) with checked default.

I tried the same above but it’s not work, please help.

4

Mylovetron wrote:

when i select trademake, it would show all model(dynamic) with checked default.

You should not need to do anything if you have set up Dynamic Selection Lists because the options in the child field are changed according to the parent field.