I need to create a database holding the results from various tests on scientific samples.
The only data that is common to the test results is the sample they were carried out on so I have placed the results from each test into individual tables, in my test database I've set up these tables but now have a problem finding records.
In order for the database to meet it's purpose I need to be able to identify particular subsets of samples from results across all the tables, For example I need to find any samples that have value x in a particular field of table 1, value y in a particular field of table 4 and value z in a particular field of table 9 (i.e any combination of fields in any table).
As I understand it in find mode FM can only search records in one table, if this is the case does anyone know if I can get FM to carry out the type of search I outlined above? Is there a particular structure I must put in place to achieve this?