Indexing a new related table
I have been given an existing database of "job tracking records".
A requirement is to add several new fields to each existing job record.
Rather than ballooning out the number of fields in the existing table which already has a very large number of fields in it already, I intended to add the new fields via a new related table.
I have created a new table and created the new fields and linked the new table to the original table by creating a relationship between a indexed field in each table.
I think I am missing a step somewhere. I think I need to somehow create new indexed empty records in the new table for all the records in the existing table?
Is this correct, how do I go about this please.