AnsweredAssumed Answered

When to split a table?

Question asked by cwcrogan on Dec 31, 2016
Latest reply on Dec 31, 2016 by David Moyer

I guess this question isn't specific to Filemaker but more a general database logic question.


I have a database with around 10,000 records (addresses in a town). About 1,000 of which have persons to notify in an emergency attached (from 1 to 3 people). There will be nearly no duplication of PTNs. Does it make more sense to have the PTNs (and their phone(s)) as fields in the address table adding 6 or 9 (3 PTNs with 2 numbers each) extra fields or to create a new table of PTNs (people)? The former will have 9000 records with 6 or 9 empty fields which I'm not sure has any overhead or not... I'm leaning towards the creation of a second table but would like some input as to which is better and why. TIA