Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    4

    Question Unanswered: Polymorphism in Microsoft Access

    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.

    Damon

  2. #2
    Join Date
    Feb 2003
    Posts
    4

    Lightbulb

    Perhaps, I'm looking at this the wrong way. If I set up a separate table for each appointment type, I could use a union query to view the common data. Would this be a more direct approach?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •