AnsweredAssumed Answered

How can I create tables with multiple keys

Question asked by liverpool101 on Jun 29, 2017
Latest reply on Jun 30, 2017 by gofmp15

Sorry but I'm a newbie. Maybe this has been asked before.

I'm trying to create a healthcare application and I need to be able to create the structure below:


Patient Table - Primary Key MRN #

Visit table - Key Date within MRN

Orders Table - sequential starting at 1 (auto increment by 1) within visit date within MRN



MRN 123

         visit 03/21/2015

                order 1




     visit 04/12/2016

              order 1



mrn 6354

       visit 05/25/2015

              order 1



how can I accomplish this?

Any help would be greatly appreciated

(BTW I'm on Version 11 because I still run XP (and so do my clients))