hello all, I'm looking for a bit of guidance on how to relate my data. Im building a database of experimental data for compounds Iv made. I have one table which contains information about each compound. I then have another table which describes an experiment. For each experiment I test three different compounds, so I have three different sets of fields in the second table (compound 1...3, results 1...3 etc.).
What I want to do is to be able to pull all the data for a specific compound, i.e. generate a new table that pulls the experimental data for a specific compound from all records in the second table.
I hope this makes sense, Im still a newbie with filemaker and maybe not sure how to explain conceptually what I am trying to do.