Populate a table from another table column

  • Thread starter Thread starter Bo Harris
  • Start date Start date
B

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?
 
Bo said:
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?
Click to expand...

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.
 
Back
Top