I have a table which has too many fields which contains various aspects of the product.
Since the database is hosted in filemaker server and accessed via internet, I think it will cause unnecessary load since I think the whole record is downloaded even if I need just a couple of fileds in certain layout.
I think it will be better to split the tables into multiple tables with relevant data. This will cause one to one relationship. Is it good or bad?
If it's good to do that then is there anyway I can automatically create record in other related table whenever the record is added in the original table?