Solved

Access 2010 Form for Order Entry

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now