jpflana
Posts: 13
|
| Posted: 08/10/2006, 8:19 AM |
|
Working from the "Updating Many-to-Many Relations via CheckBox List" example, is there a way to display one or multiple checkbox lists by another subset on the same form? For example, if there was a project_category table and you added a "product_cat_id" field to the projects table. Could you list all of the individual projects but display them by category with a description label separating each project category?
I've given an example of what I'm looking to do below.
********************************************
Finance - ongoing efforts to help our company track and manage company finances.
[ ] Invoice Management System
[ ] Billing Software Update
[ ] Payroll Accounting
Inventory - projects to help increase efficiency and reduce inventory costs.
[ ] Inventory Tracking System
[ ] Warehouse Replenishment
[ ] Truckload & Delivery Optimization
Sales - building tools to assit marketing and sales departments to increase revenue.
[ ] Regional Sales Reporting System
[ ] Development of Market Analysis Tools
********************************************
The projects_employees table would not be changed. You would not need to insert the "project_cat_id" value into the table, only the "project_id" & "emp_id" as it is currently designed. The only question is: can you diplay the CheckBox list (or multiple lists) by category and can you insert all of the values in this ManytoMany relationship?
---Thanks
|
 |
 |
|
