AnsweredAssumed Answered

Indexing a new related table

Question asked by PhilipIrving_1 on Apr 19, 2015
Latest reply on Apr 19, 2015 by PhilipIrving_1


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.