AnsweredAssumed Answered

New table or additional fields in existing table?

Question asked by tadzyh on Apr 16, 2013
Latest reply on Apr 16, 2013 by LaRetta



I'm wondering how FM12 manages its memory for empty fields in a record. I have some data (test data) that is rarely populated but is only related by a 1-1 relationship to my main entity (activity) which has its own table. The question is is it efficient to create these fields in the main table or would it be better to create a separate table for my rarely populated fields and only create a record when the data is populated?


Thanks for any advice.