Order management system - multiple data sources
Posted: Fri Jan 11, 2008 12:11 pm
I am currently writing an order management system for a client of ours. They have 3 main sources of sales... and all of these sources can have their own "order number" or "invoice number" or what-have-you. I am having a hard time making a design decision on how I should manage this on the database level. I need to be able to sort all these orders by their source, as well as look them up by their source's order number. There is a possibility (although slight) that because of the multiple sources, I could end up with two orders with the same id. I'm not even going to tell you guys how I am doing it now, because I want to get un-tainted advice. My solution is proving to be very difficult to keep straight, and I just want some advice. Thanks! 