creating a new database
I am a beginner in databases…I would like to build a database that keeps track of my insect survey work. I will have different surveys. Each survey will have different locations that I visit numerous times and I want a list of the dragonfiles or butterflies I observe. I could see many species on a given day. I’m confused on how many tables I need. One for surveys, observations and species? And then if I list the species in a portal how do I get the list of species out of a portal into a report? Thanks for listening! I have FileMaker 10.