Solved

Access 2010 Form for Order Entry

Posted on 2011-02-22
5
858 Views
Last Modified: 2012-05-11
I am moving a database from Gupta SQL to Access 2010. I have an input screen I am trying to duplicate but an having issues understanding how to best set it up.

There are 2 uses for the screen. First is for an existing order lookup. You can drop the "Number" field down to the order and the Sold to, Ship to and the line items will appear at the bottom.

Or for new order entry, you can drop the Sold to down and it will autofill the address, increment the Number to the next available.. and you can then also select a different ship to address (from the same database as the sold to). Finally you can then enter the items in by putting in the qty and getting the descriptions from clicking the descrips button and looking up the item in the products table.

I have tried with the main form being a navigation form and then putting the the customer lookups as sub forms but whitle they work as the individual forms it breaks when I put it into the main form (main form is built on the Products table is probably the reason..

but any quidance/ suggestions will be appreciated.
MainScreen.JPG
0
Comment
Question by:911bob
  • 3
  • 2
5 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 34952939
I think the main form should be based on orders, not products.  The Sold To and Ship To subforms could be linked by (say) CustomerID, and the datasheet subform by OrderID (presumably it represents order details).  Product should probably be selected from a drop-down in the datasheet.  For more detailed analysis, we would need to see the database.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34952959
If you do need the main form to be based on Products, then you may need a subform for orders, linked to Products by ProductID, and under it the other subforms (nested subforms, in other words).
0
 

Author Comment

by:911bob
ID: 34954809
Thanks, let me try your suggestions and I will be back on how I make out..
0
 

Author Comment

by:911bob
ID: 34956273
Here is a schematic of the tables I am dealing with.. just for future reference.
Relations.JPG
0
 

Author Closing Comment

by:911bob
ID: 36339320
never implemented.. but sound reasonable
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question