AnsweredAssumed Answered

Help with data relations

Question asked by RobThatcher on Aug 15, 2016
Latest reply on Aug 15, 2016 by Mike_Mitchell

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.

many thanks!