juca

Create a research button related to different field

Discussion created by juca on Jun 9, 2017
Latest reply on Jun 9, 2017 by mikebeargie

Hi,

 

I just started on FileMaker Pro and have the version 12.0.4.0

 

I am trying to make a database and would like to make on a layout "Human MENU" different fields ( "Freezing Date", "Initials", "Patient ID",..., "Origin") like on the picture

and that we can fill as many fields as we want. For example only fill the "Freezing date" and the "Patient ID" out of the 7 possible fields and then click on a button that will move you to the Layout "Human Database" and only show results that correspond to all my fields at the same time.

When I say fill in I mean choosing in a drop down list that I already created for each field.

 

 

For now I am capable of doing so but only with 1 field, I don't know how to make a button that is "connected/linked" to several fields...

This is how I did it on another file:

 

"Tube Location_DT" being my database where I want to see the result.

Like that I can sort my database by the category "Designation of Tissue" with only the records that correspond to what I enter in this "Designation of Tissue" field.

 

 

Thanks in advance for the help!

 

Best,

juca

Outcomes