Hi all,
I just started working for a new employer and the system that I'm to build seems pretty straight forward except for a few things.
Before I came they were using excel files to put together orders. Fairly straight forward except that they're used to using excel where they have a lot more flexibility in how they enter data. For instance when they enter a product code they want the unit price filled in. Simple enough but they also want the ability to modify the unit price if needed. Ok so I can't just store the product code in a table and do a join. I need to store the unit price with the order details table. I figured this much. But there's a couple other columns where they enter numbers most of the time but sometimes they put a couple words as a note.
Unfortunately, I'm not sure how to duplicate this flexibility in a datagrid or database.
Anyone ever have to deal with something similar?
I just started working for a new employer and the system that I'm to build seems pretty straight forward except for a few things.
Before I came they were using excel files to put together orders. Fairly straight forward except that they're used to using excel where they have a lot more flexibility in how they enter data. For instance when they enter a product code they want the unit price filled in. Simple enough but they also want the ability to modify the unit price if needed. Ok so I can't just store the product code in a table and do a join. I need to store the unit price with the order details table. I figured this much. But there's a couple other columns where they enter numbers most of the time but sometimes they put a couple words as a note.
Unfortunately, I'm not sure how to duplicate this flexibility in a datagrid or database.
Anyone ever have to deal with something similar?