Multiple tables

[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?

:banghead:

 

[jdraw]

You need to research database design and normalization.
Here's a tutorial that should help you.

Good luck.