Simple sales order entry application

[BigDaddy]

Hi, I am using a wet and cold holiday weekend to learn about Access. I want to create a simple sales order entry function.

I have set up 2 tables Orders and Order Details. The Orders table holds order number, customer, due date, etc and the Order Details table is to hold the line items (product, quantity, price, etc). So far, so good.

I have created 2 forms and made the Order Details form a subform of the Order Header form. So far, so good.

I have 2 questions arising from this.
1. How do I get the cursor to tab from the last field of the header form to the first field of the details subform? When I get to the last field of the header form it just goes to create another order.

2. Is it possible, and if so where do I get info on how, to enter (and show) many detail lines for the one header. This is a normal sales order situation, customer stuff followed by 5 or 6 lines of products on the order.

I have two old (Windows 95) MS Access tutorial manuals, beginners and advanced but can't find the answwers there. I am using MS Access 2000.

Any help or pointers to where I can get the help would be appreciated.

BD

 

[BigDaddy]

I have solved the first of my questions, how to move to the first field of the subform, but it only works on existing records. When I create a new order header record and enter the last field I get an eror saying "You cannot add or change a record because a related record is required in table "Order Details".

Well yes that is true and that is where I want to go to create that related record! Grrrr!

 

[ansentry]

Do you have your Child and Master fields in your subform linked?

I notice that you have an Order form and Order details form. I feel that you need at least is a table for your Customers and one for your Products. When you have a database for "Invoicing" you have to be aware about the problem you may have with pricing.

This type of database is one where you should store the price in the order details table and just not link to it.

The reason is that if you had a link only, when you updated pricing it would be reflected in the order detail table. Have a look at my small sample it may be of assistance to you.

Have a play with it by changing the pricing of the tblParts.