Lynn Pettis (4/6/2012)

---

Now you are confusing the issue. If Item1 has...

---

so its legacy that you are stuck doing it this way. its this way now so it has to be this way when we move to the new system?

in that...

capn.hector (4/6/2012)

---

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

to lynn's point. if 6 months after you start using this you have to change the pieces per pack you have to make sure to update...

Just for the information, I have edited my question and put in some more info. If anyone wants more information, please let me know and I will update the question...

capn.hector (4/6/2012)

---

to lynn's point. if 6 months after you start using this you have to change the pieces per pack you have to make sure to update every item...

capn.hector (4/6/2012)

---

ok first thing is i would move your conversion factor to your unit table, makes for easier changes with out haveing to make sure you update every conversion factor...

Moreover, to keep things simple, I have not mentioned that there are multiple measurement groups like mg, gram, kg OR packs, carton, pieces etc. as that part could easily be...

Lowell (4/6/2012)

---

are you storing just the xml in the database, or processing the xml?

if you are processing the xml, don't you stick the data into a Product Sold Table somewhere?...

I would have to disagree on that last point, I find learning the hard way the better way. Yes we are all human at the end of the day and...

Dev (11/28/2011)

---

jewel.sacred (11/28/2011)

---

I think it is not OK (not always atleast). Imagine the hard...

I think it is not OK (not always atleast). Imagine the hard disk gets full and...