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

 

eg

MRN 123

         visit 03/21/2015

                order 1

                          2

                         3

 

     visit 04/12/2016

              order 1

 

 

mrn 6354

       visit 05/25/2015

              order 1

                       2

 

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))

Thanks.

Outcomes