Infections

[endri81]

Hi
My form is a checklist(Yes/No) of infective and chronic diseases that patient can have.Except the most common problems I have a field for specifying the name of disease if it is not listed.Do I have to create a separate table for chronic diseases and a separate table for infective diseases?How to specify the disease not listed in my tables?Any best practices?
Currently I have specified a table dictionary where are mentioned all the diseases and a table types where are mentioned chronicdiseases and infectiousdiseases variables.My form is feeded by "faktore rreziku" table.
The structure is shown in attachment.
Best regards

 

[PNGBill]

Have One Table for all diseases and have a field where you will type Chronic or Infectious or maybe some other words as required.

For the Form you don't use the Table as the List but a query.
The query will have criteria Chronic or Infectous as required and only those disease names will appear.

It is quite common to use a query for this purpose as you can Filter the records, as mentioned above but also have the query sort for you as well.

You don't want separate Tables for every disease group just like a school will have Student Table and use queries to filter the records by Sex - Girl or Boy or by Grade as required.