Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access 2010 Form for Order Entry

Posted on 2011-02-22
5
Medium Priority
?
866 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

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.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

618 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