Access Database form and report

I need a couple of Access Database forms and some Reports built. It needs to be added to an existing application written in Access, and the back end is SQL Server. The software is the back end for an internet business. It downloads orders from the web, and allows us to process the orders. At the end of each day, we update the status of each order, some of the statuses = "Order Backordered". Each order is tracked in two tables, one Order, which has common information that one would collect about an order. The other table is Order Details, this table contains one line for each item ordered. Today, we can tell which orders are on backorder, but not which items on the order. The form will record this information. There is some followup work for a couple more forms and reports after we get started, and we can add those using a private auction. For now, I need the following form and report: ITEMS BACKORDERED FORM I need a form that will cycle through the orders from today (I'll show you how to get those records) and display each item ordered on the screen. The form should have a checkbox that the user will check, and the check will indicate that the item is not in stock. The form should also have a button that the user can push in the event that all items are out of stock. The form will record the out of stock condition for each item, and store the checkbox state in a field in the Order Details table. The user will press a next button, and the form will cycle through all of the records selected. When the form is opened, it will also calculate an identifying code, and it will store this code with each of the records, and it will also store it in the Order table for that order. Think of it as a purchase order number. Also, the form will update a couple of fields in the order detail record from info in the order record when the backorder info is saved. PACKING SLIP I need to modify the existing packing slip so that an asterisk is placed next to the item if the item is on backorder. ## Deliverables There is one more thing. You will need to VPN to my computer, and do your programming directly on our system. We're on the EAST COAST of the US, and you can work during our daytime hours. I'd like to choose a coder tomorrow AM, and begin work tomorrow AM. This is relatively simple, and I would expect that you could finish the two changes by end of day tomorrow. I will show you the tables, and everything you need so that you can get right to work. I need this right away, so your availability to begin will be a significant factor in your selection. Also, you need to be available during our regular business hours. Thanks very much! George