Populate a table from another table column

[Bo Harris]

Is there an easy way to fill a column in one table based on what is entered
in another table? For example I have a table for a list of raw materials.
I want to automatically add those materials to an order guide table, so that
any raw material added to the database is automatically on the order guide
table.

Any Suggestions?

 

[Joseph Meehan]

Is there an easy way to fill a column in one table based on what is
entered in another table? For example I have a table for a list of
raw materials. I want to automatically add those materials to an
order guide table, so that any raw material added to the database is
automatically on the order guide table.

Any Suggestions?

I don't think you want to do that. It sounds like you are trying to set
up your database as a spreadsheet. In a relational database you would have
a materials table and you would reference that table and the order guide
table from the same form. Since I don't know what the real relationships or
uses of your tables are, I can't offer much more specific.

You may want to take a look at the sample database that comes with
Access to get the idea of how this all works.