Hello AccessForums.net,
I have a question as I am very new to Microsoft Access. How would I create an interactive form like this one below (I made the following picture on photoshop).
I would need 2 drop down menus, one of them would be with suppliers and the other one would be for employee names. Not too hard to make in a database, I would just need to know how to make an interactive form like this and how would I call up the data in a different database (suppliers or employees).
EDIT: It wouldn't be a random order #, it would be an order that would go up by 1 every time a new purchase order was filled out.
Once I have made the interface and the purchase order, how would I go and make each new purchase order that is made have a unique number with a date in front? For example, 2010 0001. How would I have it so on each new purchase order, a new number would be made?
Thanks for your assistance.