Is there anyway i can assign categories & depts fast

I don't think Wizard really help you do you know how to write the SQL query if so. then you can do it very easy may be a min.

Load all the department and categories through excel/text file to department and category table. Have a list of item belong to department and category and update yoru data using the SQL if you do not know let me know. For quick response snipped-for-privacy@yahoo.com

just for your info:

1. Load Department
2. Load Category
3. Load New table called itemtmp which contain the link of department and catogory as item does not need the name of above field but the link ID so you can do like.

Update Item Set departmentIDÞpartment.ID from itemtmp,Department where Itemlookupcode=itemtmp.code and Department.Name=itemtmp.DepartmentName (optional may be department code can also be link for this)

"Peter Liu" wrote: