I am trying to figure out the best way to design this Database.

I am trying to track outcomes for patients. Vision is what I am tracking over a period of time by the particular surgeon who performed the surgery.

I want to put the data into a report which will go into a chart.

Questions…

I know I need a Patient Table but should I put their outcomes in this or create a separate table and just create the relationship. I know I will need a surgeon table.

Also All the fields with the exception of one will drop down on the main patient entry form. Should I create a table of static values for the score values for the patients vision?


Thanks

Trent