best database construction method
I am a little confused, when I purchased filmaker 9 advanced, I posted a few questions on various forums on the best way to construct my database:
option 1: 1 database with many tables all linked
option 2: many databases linked
all the responses were to have 1 database and many tables, so I have gone down that route. However I am looking into filmaker 10 and have downloaded the business resources kit as I like the email and stock control bits so I was intending on hashing it all together. But this uses multiple databases linked together? What is the best way to do this and are there any advantages or disadvantages in either route?