Help with search function

[NewtoFileMaker88]

Hi,

I setup a database for patient information, and am now at the stage of learning how to generate records based upon the data that we input. I have a couple questions, and would really appreciate some help to point me toward the right direction.

I have my database setup so that there is a layout called Patient List, with patient names and identification numbers, and a table called Main Table, which has a tab control on a layout for the table which has individual portals to separate tables, such as MRI data. I attached a copy of my database to show how I have set it up.

One function that I would like to be able to do is to be able to generate a list of patients who for instance are diagnosed with myoclonic atonia. This is found in the SeizureType table, and a portal showing this information is in the Seizure Type tab of the tab control in the Main Table layout. I would like to be able to ask File Maker to generate a list of all patients who have the "Yes" checker box marked in the field for Myoclonic Atonia. Is there a way to do this?

Other notes:

I will probably rename many of the fields in order to facilitate analysis of the data...many of the field names are a bit chunky. I was thinking of maybe even going with a lettering system for the field names in some cases in which there are long-winded questions, to make it easy.

I plan to combine the fields in the Demographic, seizure type, etiology, and syndromes tables all into one table (and then separate them into the same tabs in the tab control) soon.

EDIT: Also, does anyone know of an easy way to copy and paste fields from one table into another? I want to merge 4 tables into one single table.

Patient Database.fp7.zip