Getting data automatically from a field on a second table based on the input to the first table.

[Grahamiwa]

I am a very small manufacturer of cured meat products and started a database to store recipies and history of each batch I produced.
Time has evolved and the database has grown arms and legs.
In my recipe table I now have a field for shelf life for that particular product.
I have a product log table that contains the Recipe ID number.
What I would like to happen is that when I create a new record in the product log table and enter the recipe ID number the shelf life for that product is copied from the recipe table into the corresponding field in the product log table.
I have virtually zero skills at writing code.


Thanks
This will probably be the first in a number of "How do I ..." posts

[orange]

See the Database Planning and Design link in my signature for several articles. I recommend that you watch the Richard Rost series to get a better understanding of tables and queries with Access. Research Normalization to help with table design and modification. I also suggest you work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in that link. You will experience a process that you can use with your own "business" description to ensure the design of your database.
Good luck.