?
Solved

Access 2010 Form for Order Entry

Posted on 2011-02-22
5
Medium Priority
?
865 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 31

Accepted Solution

by:
Helen Feddema earned 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

777 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