Solved

Access 2010 Form for Order Entry

Posted on 2011-02-22
5
862 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

Don't miss ATEN at NAB Show April 24-27!

Visit ATEN at NAB Show to learn how our "Seamlessly Entertaining" solutions deliver fast, precise video streaming without delays for the broadcasting and media environment. ATEN will showcase its 16x16 Modular Matrix Switch (VM1600) and KVM Over IP Solution (KE6900 series).

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

679 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