Table autofill

[jesswoo]

Hello. I have a question about tables autofilling. I think you could say I am less than a novice because I just played around with Access until I got it to do what I wanted.

I have this database to create work orders for my company. I learned how to use Access by creating this database...

Anyways I have the work order form up and it works and autofills and all but I am wondering if there is a way I can get info in the tables to autofill.

Here is my example. I have a table the has paintID, Manufacturer, Location. I also have the input table which I used to create my form that has all the fields I need for the work order which include the fields from the PaintID table.

The unique field I had to go off of to make it all work is the part number. For each order if I haven't already entered the part I enter the part and the customer and all the other fields for that part.

What I want to know is if there is a way that I can get it so that when I type in a paintID into the input table the corresponding location and manufacturer fill into the corresponding fields on the input table.

Note: This is not for a form, but a table for a form. My form autofills literally every field based on the part number I just would like to know if there is a way to make the data entry easier.

Thank you in advance!

 

[plog]

That's not how databases are to work. You shouldn't store redundant data. All you need to store is the unique ID value from one table in the other table. Then when you need all the other data you create a query, link your tables by the corresponding field and then bring in all the fields from the tables you want to use.

 

[jesswoo]

So I need to keep a diferent database with a table for paint information? We have over 200 different types of paint in stock. I have to have a record of that so I know where the paint is so I know what to type into the input table fields.

Your message does not make sense, I am not storing redundant data I am trying to connect data from other tables into a table that I created a form from and I have no idea how to create query or how it works. As I said I am a novice not a genius..:banghead:

 

[plog]

Can you post either your database or some sample data from your tables. If posting data use this format:

TableName
field1name, field2name, field3name...
1, "Red", "Latex"
2, "Blue", "Oil"