Access autofill from one table to another

[chorne]

I am new to access.



I have created a table that list all of our Product #, products, sizes, and colors.

I then have another table that we use as a log and individuals will be adding entries as they come in.

I would like for the second table to autofill based off the Product # from the first table when selected.

Can anyone help me with this??

[ranman256]

This is what queries are for.
Create an update query, join the 2 tables on the common field ,
then update the fields needed.

[chorne]

I have created an update query and joined the 2 tables. However, when i select the product # that is the only field that is filled in. The other fields are left blank.

[aytee111]

I'm not sure why you are trying to repeat the data. The definition of a normalized database design is that fields are kept in only one place (among other rules), except for the primary key. So all you would carry on the second table is the key, the rest of the data is then retrieved thru subsequent queries, as and when you need to display them.

[chorne]

I am not trying to repeat the data. I made a table as a legend for the different product #, size, and color. In the other table I want the users to enter each product when it comes in along with measurement information. But instead of them having to type all of the known data, I want to them to be able to type the product # and then the product information autofills itself. Then all they will have to input is the measurements taken.

I am going about this the wrong way?

[aytee111]

Users should not be entering information directly on to a table - that is what Excel is for! Create a form where they enter the product # and the rest of the data is then retrieved and displayed.

[chorne]

How do I get the form to auto-fill?

[aytee111]

You will have to arrange for that to happen - once they enter a product id then you will retrieve the data and display it. This requires creating a form for the first table with a combo box for the product - which will display the data retrieved once they select one, and a subform linked to that product ID where the user can enter the log information for that product.

Here's a good place to start: https://www.youtube.com/watch?v=-fQ-bRllhXc