OK I can understand that easy enough.
Part of what I am struggling with is what information wants to be in what field.
Either a sample database with data or good definitions would be very helpful.
I'm sure who ever designed it know the difference between ProductCategoryID and CategoryID.
I haven't a clue myself.