I am trying to use Filemaker Pro to create a dashboard with dynamic elements inside. For that I have created different simple tables with links. But when I looked at some videos on Youtube about Filemaker Dashboard, I understand that all the data are stored in one big table. I would like to know what is the best the solution: one big table or several simple tables?
For my understanding it is easier to get the data from one big table by using Execute SQL functions like "SELECT FROM WHERE" but is it possible to do it also with several tables?