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.