infobih
Posts: 58
|
| Posted: 06/12/2006, 1:47 AM |
|
Hi
I need to populate Listbox from table like using for directory
Table is Categories
Fields are:
cat_id,cat_id_parent,catname
where cat_id_parent = 0 for using parent CAT, all others subcat have the same cat_parent_id for each category
When I create bormal Listbox in record Form with catname I want to have format like this
Listbox:
Category1: Subcat1
Category1: Subcat2
Cetagory1: SUbcat3
Category2: Subcat1
category3: SUbcat3 etc etc
Or like this
Category1
subcat1
subcat2
subcat3
etc
How can i have sql statement for List box
any solution ? Help please
|
 |
 |
|
