Auto-Fill

[sophiecormier]

Hi,
I'm a newbie in Access but I want to do a form where I enter a value from a table and the other fields fill in.

The table I have is Data Input: (Where everything is stored)

Trip ID
Driver
Date
Truck #
Trailer #


Product
Origin
Origin Ref
Destination
Destination Ref
Weight
Customer
Load Type
Cargo Units
Driver Pay
Extra Pay
Customer Pay
Fuel Surcharge
Invoice #
Comments

It's a trucking database and we enter a lot of the same loads everyday and I want the following to fill out automaticaly when I enter a value (Ex. Load #):

Product
Origin
Destination
Customer
Load Type
Cargo Units
Driver Pay
Customer Pay

I know I have to do another table with all this information in but I don't know how to get this all set up. I've checked out several places for examples but I have a hard time following. Any help is much appreciated.

Thanks!

[NTC]

If I understand you; Those fields should be designated as 'LookUp' fields in the table.

Before you do that - you need to make each item its own separate table.

The easiest analogy of this is the 2 letter state initials; AL MI GA etc... one makes a table with these. Then in the typical customer or orders table or whatever that has an address field - the State field is a LookUp field that 'points' to your stand alone States table.

One can not design a db without a textbook. Get a book in your version from Amazon or any big book store. Example of LookUp field types will be there.

Hope this helps.

[sophiecormier]

The way I was thinking was when I typed in the "Load#" I would get all the information this information below entered and I could go in and add the remainder of the info. Is this possible or do I still have to go field by field?

Product
Origin
Destination
Customer
Load Type
Cargo Units
Driver Pay
Customer Pay

Thanks for replying!

[NTC]

Well that is the next level. Obviously you must have all the data for each Load# in its table. At this point one is in the realm of standard db activities. Definitely in a form that is to display the info - one puts a combo/list box in the header and uses it to select the record to display. That is the mainstream use of a combo/list box.

My original understanding of your post is that you wanted to streamline the entry of repetitive info. But if your info is already in the db - then its display really isn't 'autofill' so to speak - - because you are not filling in new info - it is simply displaying the info already there. semantics.

Hope this helps.