How to handle a select list in editor?
How to handle a select list in editor?
Here's my dilemma.
I have a datatable that lists users. When you click on the EDIT button, an editor window opens.
In the MySQL user table, there is a field called addresses which is a comma-delimited list of address id's from the address table.
In the editor, I need to show a multiple select list of the addresses that the user currently has access to which highlights the one's they already have.
The address listing has an id and name field. The values in the address field for the user relate to the id in the address table.
A user belongs to a customer, and addresses relate to the customer. In some cases, a customer might have hundreds of addresses that a user can have access to, so listing them with checkboxes isn't an option.
Any ideas on how I can handle this? I have ported an application from another language to PHP and in the old system (no datatables) it was relatively easy to handle.