I'm incredibly new to filemaker, but i've been asked by my professor to assemble a database of projects that our lab has been working on and I'm stuck on how to go about this. The task is essentially this:
Gather all unfinished projects, with associated literature and data, and compile it into a neat database, where you can just click on the project and see a description and the data that has been collected for it.
So I've created a list of the projects, and their descriptions and their investigators and their literature, and I have all of their data. The only problem is that there are multiple spreadsheets of data that have next to nothing to do with each other. The projects involve numerous studies and have multiple surveys that ask different things.
What I want, Ideally, is a list layout of the projects (each project is a record) with a button that takes you to another lay out with the descriptions, and yet another button(s) that take you to the survey description and response data.
Any tips on how to make this happen?