Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Nick
Posting Yak Master
155 Posts |
Posted - 2001-10-28 : 10:19:00
|
Hello Again-I'm desigining a DB for a medium sized manufacturing company. Right now they use a combination of badly designed spreadsheets.One feature that they want the DB to have is the ability to look at order backlogs, and order scheduling. I can provide this ability by adding a due date to each order. The problem is that many of the orders they get come in the form of "100 parts starting on mm/dd/yyyy and 50 parts every week after until the balance of 1000 parts is met."My initial thought was to have a products table, an orders table, and a n-to-n relation table between them. This should work (although I'm willing to take better suggestions.)The problem comes with the order entry. I would like to do it via an ASP web page. My thought was to give the users a dropdown box with all of the part numbers. An initial shipment quantity and date text box. A dropdown box that allows for options such as every month, every week, every two weeks, and the total quantity requested.I guess my real question is how would I write a stored procedure to take those inputs and enter into the orders_products table the correct info? Am I going at this the wrong way? Thanks in advance! |
|
|
|
|