Multiple Table Scenario

[chriscardwell06]

We have a database that I am taking over that controls all our jobs through engineering. We are adding some functions for manufacturing currently. I could just go add the new fields to the main table but it is really starting to have a lot of fields and is getting cumbersome to navigate. What I had hoped to do is create a new table and link the fields that I need on both. But I couldn't get it to populate the new table with the records from the old table. Certain fields like sales order, customer, part number, etc etc need to be on both tables. How do I get the second table to populate after making the relation and am I even going about this correctly?

[orange]

Chris,

You should read and work through this tutorial.

[Dal Jeanis]

Yep, time to renormalize your database so it navigates easily.