Autofill data?

[dmmitchell]

Hello --

I am a student with very little background in Access. I am trying to
setup a database that would auto-fill fields based on data in a
table... I want to enter a company name, and then the company's price
information, contact information, etc., should show up on the form so I
can complete an order form...

Any help would be greatly appreciated.

Derek

 

[Rick B]

I would suggest you look at the Northwinds sample database that ships with
Access and see how it does this on the order form. Or, read previous posts.
This is a very common question.

Since you are in a class, I'm giving you some resources, not simply
answering your question. That way, you'll better understand how it works.
Feel free to post back if you get into it and have specific questions about
how to make it work with your data structure.

Good Luck,

 

[dmmitchell]

Thanks. It's not actually a project for class... it's something I'm
doing for a summer job to make one of our processes a bit smoother and
require less paper shuffling.

Thanks for the information.

Derek