{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil\fcharset0 MS Sans Serif;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\sb120\tx90\tqr\tx8640\cf1\lang1033\fs16 H:\\data\\database\\medrec.mdb\cf0\f1\fs24\tab\cf1\f0\fs16 Tuesday, March 15, 2005\fs21\par \pard\tx90\tqr\tx8640\fs16 Table: Data_FH_Conditions\cf0\f1\fs24\tab\cf1\f0\fs16 Page: 1\par \cf0\f1\fs24\tab\cf1\ul\b\f0\fs16 Columns\fs21\par \pard\sb120\tx735\tx5055\tx7287\cf0\ulnone\b0\f1\fs24\tab\cf1\f0\fs16 Name\cf0\f1\fs24\tab\cf1\f0\fs16 Type\cf0\f1\fs24\tab\cf1\f0\fs16 Size\fs21\par \pard\sb58\tx735\tx5055\tqr\tx8439\cf0\f1\fs24\tab\cf1\f0\fs16 Condition_ID\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Long)\cf0\f1\fs24\tab\cf1\f0\fs16 4\fs21\par \pard\tx735\tx5055\tqr\tx8439\cf0\f1\fs24\tab\cf1\f0\fs16 Member_iD\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Long)\cf0\f1\fs24\tab\cf1\f0\fs16 4\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Condition\cf0\f1\fs24\tab\cf1\f0\fs16 Text\cf0\f1\fs24\tab\cf1\f0\fs16 50\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Ozcode\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Long)\cf0\f1\fs24\tab\cf1\f0\fs16 4\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Age_of_onset\cf0\f1\fs24\tab\cf1\f0\fs16 Text\cf0\f1\fs24\tab\cf1\f0\fs16 3\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Cause_of_death\cf0\f1\fs24\tab\cf1\f0\fs16 Yes/No\cf0\f1\fs24\tab\cf1\f0\fs16 1\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Comment\cf0\f1\fs24\tab\cf1\f0\fs16 Text\cf0\f1\fs24\tab\cf1\f0\fs16 50\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Deleted\cf0\f1\fs24\tab\cf1\f0\fs16 Yes/No\cf0\f1\fs24\tab\cf1\f0\fs16 1\fs21\par \cf0\f1\fs24\page\pard\sb120\tx90\tqr\tx8640\cf1\f0\fs16 H:\\data\\database\\medrec.mdb\cf0\f1\fs24\tab\cf1\f0\fs16 Tuesday, March 15, 2005\fs21\par \pard\tx90\tqr\tx8640\fs16 Table: Data_Fh_FMembers\cf0\f1\fs24\tab\cf1\f0\fs16 Page: 2\par \cf0\f1\fs24\tab\cf1\ul\b\f0\fs16 Columns\fs21\par \pard\sb120\tx735\tx5055\tx7287\cf0\ulnone\b0\f1\fs24\tab\cf1\f0\fs16 Name\cf0\f1\fs24\tab\cf1\f0\fs16 Type\cf0\f1\fs24\tab\cf1\f0\fs16 Size\fs21\par \pard\sb58\tx735\tx5055\tqr\tx8439\cf0\f1\fs24\tab\cf1\f0\fs16 Member_ID\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Long)\cf0\f1\fs24\tab\cf1\f0\fs16 4\fs21\par \pard\tx735\tx5055\tqr\tx8439\cf0\f1\fs24\tab\cf1\f0\fs16 Name\cf0\f1\fs24\tab\cf1\f0\fs16 Text\cf0\f1\fs24\tab\cf1\f0\fs16 50\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Date_of_birth\cf0\f1\fs24\tab\cf1\f0\fs16 Text\cf0\f1\fs24\tab\cf1\f0\fs16 10\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Relationship_ID\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Byte)\cf0\f1\fs24\tab\cf1\f0\fs16 1\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Age_of_Death\cf0\f1\fs24\tab\cf1\f0\fs16 Text\cf0\f1\fs24\tab\cf1\f0\fs16 3\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Deleted\cf0\f1\fs24\tab\cf1\f0\fs16 Yes/No\cf0\f1\fs24\tab\cf1\f0\fs16 1\fs21\par \cf0\f1\fs24\page\pard\sb120\tx90\tqr\tx8640\cf1\f0\fs16 H:\\data\\database\\medrec.mdb\cf0\f1\fs24\tab\cf1\f0\fs16 Tuesday, March 15, 2005\fs21\par \pard\tx90\tqr\tx8640\fs16 Table: Data_Fh_Links\cf0\f1\fs24\tab\cf1\f0\fs16 Page: 3\par \cf0\f1\fs24\tab c\cf1\ul\b\f0\fs16 olumns\fs21\par \pard\sb120\tx735\tx5055\tx7287\cf0\ulnone\b0\f1\fs24\tab\cf1\f0\fs16 Name\cf0\f1\fs24\tab\cf1\f0\fs16 Type\cf0\f1\fs24\tab\cf1\f0\fs16 Size\fs21\par \pard\sb58\tx735\tx5055\tqr\tx8439\cf0\f1\fs24\tab\cf1\f0\fs16 Link_ID\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Long)\cf0\f1\fs24\tab\cf1\f0\fs16 4\fs21\par \pard\tx735\tx5055\tqr\tx8439\cf0\f1\fs24\tab\cf1\f0\fs16 Member_iD\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Long)\cf0\f1\fs24\tab\cf1\f0\fs16 4\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Patient_ID\cf0\f1\fs24\tab\cf1\f0\fs16 Number (Long)\cf0\f1\fs24\tab\cf1\f0\fs16 4\fs21\par \cf0\f1\fs24\tab\cf1\f0\fs16 Deleted\cf0\f1\fs24\tab\cf1\f0\fs16 Yes/No\cf0\f1\fs24\tab\cf1\f0\fs16 1\par \par Query these using:\par \par SELECT data_FH_Links.Patient_ID, data_FH_FMembers.Member_ID, data_FH_FMembers.Consult_ID AS Member_Consult_iD, data_FH_FMembers.Consult_First_Noted AS Member_Consult_First_Noted, data_FH_FMembers.Name, data_FH_FMembers.Date_of_birth, data_FH_FMembers.Relationship_ID, data_FH_FMembers.Age_of_Death, data_FH_Conditions.Consult_ID AS Condition_Consult_ID, data_FH_Conditions.Consult_First_Noted AS Condition_Consult_First_Noted, data_FH_Conditions.Condition_ID, data_FH_Conditions.Condition, data_FH_Conditions.Ozcode, data_FH_Conditions.Age_of_onset, data_FH_Conditions.Cause_of_death, lu_Family_relationships.Description, data_FH_Conditions.Deleted, data_FH_Conditions.Comment, data_FH_FMembers.Deleted, data_FH_Links.Deleted\par FROM ((data_FH_Links INNER JOIN data_FH_FMembers ON data_FH_Links.Member_iD = data_FH_FMembers.Member_ID) INNER JOIN data_FH_Conditions ON data_FH_FMembers.Member_ID = data_FH_Conditions.Member_iD) INNER JOIN lu_Family_relationships ON data_FH_FMembers.Relationship_ID = lu_Family_relationships.Relationship_ID\par WHERE (((data_FH_Links.Patient_ID)=[Enter Patient ID]) AND ((data_FH_Conditions.Deleted)=False) AND ((data_FH_FMembers.Deleted)=False) AND ((data_FH_Links.Deleted)=False))\par ORDER BY data_FH_FMembers.Member_ID;\par \par Produces recordset output which is extremely easy to display:\par \par name \tab relation disease ageonset caused death,age death etc etc\par -------------------------------------------------------------------------------------------------\par Joan smith Mother Hypertension 55 n\par " " " angina 60 n\par " " " AMI 61 y 61\par Fred Uncle-maternal Lung cancer 77 y 78\par Peter grandfather - paternal Stroke 99 y 99\par Peter grandfather - paternal Hypertension 65 n\par \par \fs21\par }