Data Input Order Form and Combo Box issues

[Tylerluk1]

Hi everyone,



I am creating an Order Form as a project for work. I am trying to create something similar to the northwinds order form {Order Details form]. However, I am having issues creating an Order Form that has a data input form where I can add an Order that has multiple products on it but under the same Order ID number. I would like to the form to work as an order tracking form where I can see all the orders in one spot by active orders and eventually use this for sales reports etc. Does anyone have an ideas on what I could do for this? I would like the form to have combo boxes for the product name product type colors as well as status. I have been working on this form for about 3 weeks and really havent gotten any progress towards what I want. And help is much Appreciated.

Thanks

Tyler

[nick404]

If you are new to Access, consider using the form wizard to help you get your form set up and go from there until you get more comfortable with how access works.

[June7]

Use form/subform arrangement. Is that what Northwinds does? What do you not understand about form/subform?

What exactly have you tried and why doesn't it work, what happens - error message, wrong results, nothing?

[Tylerluk1]

I had some luck with the forms using the wizard, I realized that the Northwinds database had aspects which I really don't need in my database and they were only confusing me more. However, now I am trying to figure out the golden question. How do I make a form that allows me to add products will different names to one order ( ORDER ID #)? I work for a door manufacturing company and I am making this db to track our in progress work because our employees are not tracking what needs to get done in what time frame as well as paying attention to who gets what. Our orders usually consist of different doors styles per order I.e some might be doors some might be drawer fronts . I want to be able to track how many of each are on each order. I've tried searching all over for this but cant seem to find a clear answer. Any help with this will also be much appreciated.

Thanks Again!

[nick404]

So you are essentially looking at creating an invoice?

[Tylerluk1]

Sort of like an invoice, the price isn't the issue I have all of that info in quick books I need to make a database that will track all doors throughout their stages on manufacturing ( I'm using check boxes for that) The biggest issue is that under one Order number a job usually have different door styles and other accessories per order .

[June7]

Thread marked solved - is it?

[Tylerluk1]

Apologizes June 7, It was not solved yet, I still have not found a way to add multiple products to one order ID

[June7]

You need a related child table to store the multiple products associated with each order. This is a 1-to-many relationship. Then build a form/subform arrangement.

[Tylerluk1]

These products are not associated with each other they are just different styles of doors that our customer might order at once. I.E. 1- Square door, 1-Round door for the order named "June 7".
Will I still need to make this child table for this?

[June7]

Of course products are not associated with each other, they are associated with an ORDER.

As noted, need a related child table.

Review:

http://www.access-programmers.co.uk/...d.php?t=183797
https://support.office.com/en-us/art...rs=en-US&ad=US