Does anyone know what is the best way to simulate polymorphism in Microsoft Access? I am building a database for keeping track of medical appointments. These medical appointments can be primary care, specialist, dental, vision, emergency room, or routine physical exams. Each type of appointment requires the same information (AppointmentDate, AppointmentTime, etc.) but also requires type-specific information. I am envisioning one table of appointments for ease of querying - perhaps with a field called "AppointmentType" - and then additional tables that contain appointment-specific details, linked by ClientID and AppointmentID. In the input forms, I figure I can use subforms to display the type-specific details for any single appointment. The subform will change based on the value of "AppointmentType" in the master Appointments form. Reporting will be handled similarly, I guess.
Will this work or is there a better way to achieve polymorphism in Access? Thanks.