I have patients that will be having mulitple surgeries... If I want to capture that data, won't I need a filed in a table for each surgery listed?
I have a table called tbl surgery. A patient can have several surgeries in their lifetime and we want to capture that data and possibly qry it in the future. Won't each surgery require a field in a table (Surg 1, Surg 2 and so on)?