Checkbox List

Hi,
I suppose SQL should look like:

select * from Travel_Objective where `list`like '%1%' or `list` like '%3%'

Hi,

Hi Jane,
I have the same problem as above except that i am not able to populate the category field with multiple values from the checkbox.

Thus, if a user select multiple options from the check boxes my database only displays one.
Please how can i insert multiple values from the check boxes into a field (maybe separated by comma)?
Thanks in advance.

Somebody help please.

I want to be able to insert values from another table into a table using checkboxes.

Everytime i try, only one value is returned or atimes 0

Hi,
Go to visual editor,
Set the new field to store the checkbox selection to:

1. Lookup wizard
   
2. Lookup table = your_lookup_table
   
   link field = your_lookup_table_primary_key
   
   Select check box list
   
3. Try to add or edit.
   Make sure that the field to hold the check box list is character not int.
   hope it helps.
   
   acp

Hi,

1. Lookup wizard
   
2. Lookup table = your_lookup_table
   
   link field = your_lookup_table_primary_key
   
   Select check box list
   
3. Try to add or edit.
   Make sure that the field to hold the check box list is character not int.
   hope it helps.
   
   acp

Hi acpan,
Thanks very much. You solve my problem!

If you don't mind, i need further advice.
My problem really is that i have two tables (members and subgroups).

Members can belong to multiple subgroups (which you earlier post resolved) and a subgroup could have multiple members.
I implemented a master detail relationship for the two table. Now, members are able to select multiple subgroups (as checkbox option).

The issue now is that from the subgroup table, there is no way of knowing who belong to which group as the primary key field in the members table has a list of comma separated values (except where a members belongs to only one subgroup).
Thanks in advance.

Hi,
unfortunately PHPRunner do not support multiple values in the master-detail relationships.

You can create custom link using custom format on the "View as" settings dialog on the Visual Editor tab. Actual code is dependent on your tables/values.
You can publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with detailed description of what you want to do and I'll try to help you.

Hi,
In CSV, it's hard to identify the master unless you form all possible SQL

conditions for the Query in events codes. I managed to form a all

conditions SQL as follows:
" subgroup_id like 'x,%' or subgroup_id like '%x,%' OR subgroup_id like ',x'

OR subgroup_id like 'x' OR subgroup_id like '%,x' "
So if data is:
Row 1: "2,3,1"

Row 2: "1,2,3"

Row 3: "3,1,2"

Row 4: "2"

Row 5: "1,3,2"
And if you are interested in ID=2 in the CSV for all rows,

you can apply the SQL conditions will get all rows who has "2":
" subgroup_id like '2,%' or subgroup_id like '%2,%' OR subgroup_id like ',2'

OR subgroup_id like '2' OR subgroup_id like '%,2' "
That will give you all master rows who have "2" in their CSV values.
In events codes, you can do some pre-processing and get to the

above stage.
I am guessing what you need, if the above does not help,

please try Jane's advise.
acpan.

hi acpan,

I am grateful. Will try your suggestion (you guessed right) and get back.