bbdesign

Thanks for the offer, but I have 99% of the information I need, just stuck on a few fields.

I found a table called SL_DEPT which seems to have all the department codes and names of departments. However, I cannot find the link between SL_DEPT and STOCK. For example, for my DEPTCODE value 1003 in SL_DEPT ("Basketball Apparel"), the number 1003 does not appear anywhere in STOCK. The SiteLink website is working properly, including the display of the Basketball Apparel department and corresponding items for sale, so there must be a functioning link somewhere, I just cannot seem to figure out what it is.

INETDEP is completely blank in the STOCK table.

ASSOC contains some 2-5 character letter codes that I cannot decipher, and do not seems to correspond to anything in SL_DEPT.

SALES_DEPT contains 2 character letter codes that sort of make sense, but still don't correspond to the department codes in SL_DEPT, which is what I really want to do.

OK, now I'm trying to figure out how to separate out various departments from the STOCK table. I thought I would be able to use codes that SiteLink has in the URLs. For example, dept=1003, I'm looking for a field that holds the department number values, but can't find any. Is that located in a different table? Or is there a better way to separate specific departments in the STOCK database?

Other possibilities are the ASSOC or SALES_DEPT fields, maybe? They appear to have codes in them that are unrelated to the dept= value in SiteLink URLs.

Thanks!

Thank you all very much for the assistance, I think this will help a lot!