Forum Discussion
Setting up a Table. One table for all columns, or each column a table? Does it make a difference
Do the data in one row "belong" together, for example first name, last name, date of birth and place of birth of a person? If so, you should create one table - you want the data to stay together in the same row.
Or are the data not related to each other, and could one column have more or fewer rows than another column? In that case, it's better to create separate tables, so that each can be manipulated independently from the others.
Do the data in one row "belong" together, for example first name, last name, date of birth and place of birth of a person? If so, you should create one table - you want the data to stay together in the same row.
Or are the data not related to each other, and could one column have more or fewer rows than another column? In that case, it's better to create separate tables, so that each can be manipulated independently from the others.
Thanks for the quick reply. In this case, the formulae will query separate columns as needed, so better to create separate tables.
Much appreciated!