sbg2 Posted February 23, 2005 Share Posted February 23, 2005 I am in the process of updating our order system from a single file that has a field for each item that can be ordered to a new system that stores the items in a seperate Line Items file. For display and orginizational purposes I have a script that imports 1 of each particular item into the Line Items database which makes order entry much easier as opposed to selecting from a drop down list. My concerns with this system are: 1) Might I encounter problems when this system is deployed and more than 1 user tries to create a new order at the same time? Right now when a user clicks the New Order button a script is run in an Items file which finds all items marked for Orders and exports them to a file called "1 of each for US_Orders.tab". This '.tab' file is then imported into the Line Items file which gets populated with all items and sets the ID_Order to the appropriate order. When the user Prints the order any Line Item record with a 0 qty is deleted (helps limit file size). 2) When a user chooses to Edit an Order another export of "1 of each..." is executed and imported back into the Line Items file only adding items that do not exist. This can cause records that have the same ID_Order to become seperated. I'm worried about the effect this will have on performance. I suppose I could set-up a periodic export/re-import of all the line items records (sorted by ID_Order) and re-index them that way. 3) Is there an easier way to get the Single Table feel to an order system while still utilizing a seperate Line Items file? Link to comment Share on other sites More sharing options...
This topic is 6609 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now