I'm designing a semi-complex access db. as a fairly new user to Access.
It is a DB for a catering company. This DB has the following tables: Customers, Order Info (Date, time, location, etc), Ordered Goods (the items they are ordering).
I have the table relationships set up correctly as listed above.
The problem i'm running into is creating the forms. I need to create an order form which is designed for quickness and ease. The First area, the Customers I need a drop down menu, upon selecting the customer it will show their information such as the phone number, cc #, email. under that will need to be the order info which will be an input area for the information mentioned above. Under that is a multiple list item which can record multiple items at a time. There will be a Add new order(opening a blank screen), or save and exit which will return the user back to the switchboard.
Now my question is ... how do I create the drop down menu? and all the input fields to work 100%? I was told I needed to do some VBA which I have no Idea how to do.
I seem to run into problems creating the Form with all the information needed and store it properly. If you have any suggestions comments responses, etc..
Ok, so the form needs to have an underlying query that includes all the fields from your OrderInfo table + all the non-keys from Reps. Then you create your combo box for RepID. When you use it, all the fields from the Rep table will populate themselves.
It also wouldn't hurt to enforce your referential integrity.