Pathalogy lab database

[bahisht2k2]

Hello Dears;


I am creating a database for a pathology laboratory; having patient table; test advised table and Different test tables like Hematology, Serology, Urine
how to make the relationship.
Patient: P_ID;Name;Address;Visit_Date; Consultant_name(Doctors name in lookup)
Test_advise: Hematolog (Yes/No); Serology (Y/N);Urine (Y/N)
Hematology: HT_name ("HB %";"TLC";"ESR";"Platelets Count";"MCV";"Neuterophils";"Lymophyocytes";"Monoc ytes";"Eosinophils") in lookup combobox,row; HT_Result;HT_Normal Values ("M13-18/F11.5-16 gm/dl";"4000---11000/cumm";"0---15, 1st Hr";"1,50,000-4,50,000/cumm";"76---96fl";"50---70 %";"25---35 %";"02---06 %";"02---06 %") combo

the other tables are also

[ranman256]

id say:
tPatient.patientID --- tTestAdvise.patientID,
tTestAdvise.TestID --- tHematology.TestID
tTestAdvise.TestID --- tUrine.TestID
tTestAdvise.TestID --- tSerology.TestID
etc

tTestAdvised tbl,
---------------
TestID
patientID
DateOrdered
OrderedBy


tHematology tbl
---------
hemoID
TestID
test
result
etc

tUrine tbl
-------
UrineID
testID
result
etc