Thank you Jamie, that would appear to be the problem. I'll try to redo the structure from scratch. -Ruwan

-----Original Message----- From: epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request@lists.umanitoba.ca Sent: Wednesday, May 24, 2017 1:00 PM To: epidata-list@lists.umanitoba.ca Subject: EpiData-list Digest, Vol 160, Issue 1

Send EpiData-list mailing list submissions to epidata-list@lists.umanitoba.ca

To subscribe or unsubscribe via the World Wide Web, visit https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.umanitoba.ca_mailm... or, via email, send a message with subject or body 'help' to epidata-list-request@lists.umanitoba.ca

You can reach the person managing the list at epidata-list-owner@lists.umanitoba.ca

When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..."

EpiData-list mailing list ___________________________________

Today's Topics:

1. Problem defining the key variable for a relational database (EpiData development and support) 2. Re: Problem defining the key variable for a relational database (EpiData development and support)

----------------------------------------------------------------------

Message: 1 Date: Tue, 23 May 2017 21:10:26 +0000 From: EpiData development and support epidata-list@lists.umanitoba.ca To: "epidata-list@lists.umanitoba.ca" epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Problem defining the key variable for a relational database Message-ID: MWHPR1201MB01589C72CC80AFF050E2F45696F90@MWHPR1201MB0158.namprd12.prod.outlook.com Content-Type: text/plain; charset="us-ascii"

Hi there,

I have a relational database with three key variables (district_id; health facility_id; patient_id). It is relational as there are three forms: Patient Demographics, Patient Progress, Laboratory.

For the Progress form, for some reason, when try to enter the variables in the key (Right click form>Define key), I cannot add anything more than the patient_ID. The other options are greyed out. For all other forms, entering multiple variables in the key is no problem.

I'd appreciate some advice on what (obvious) option I am missing.

Thank you!

Ruwan

------------------------------

Message: 2 Date: Wed, 24 May 2017 11:35:46 -0400 From: EpiData development and support epidata-list@lists.umanitoba.ca To: EpiData List epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] Problem defining the key variable for a relational database Message-ID: 89B424E3-7B17-4F75-8E4B-8106D0CD3AD1@bell.net Content-Type: text/plain; charset=utf-8

I assume that your structure is like this:

Demographics form ?> Progress form (1-many) ?> Laboratory form (1-many)

Once you define a key(s) in demographics, it automatically defined for the child forms because it(they) define the relation. When you define a new key in progress, they key or keys you defined for Progress show, but are greyed out because you cannot remove them. So in progress, you can add a new key, which will be automatically defined for laboratory.

You MUST know what your relationships and keys are before you start. Once you have created a subform, you cannot change the keys in the parent form. I find it best to set up the data forms with just the keys and maybe a couple of other fields first, to make sure the structure works for you. You can defined the type of relationship (1-1 or 1-many) and try out the flow of data entry from one form to another and back again.

Then add in the rest of the fields.

Jamie

On May 23, 2017, at 17:10, EpiData development and support epidata-list@lists.umanitoba.ca wrote:

I have a relational database with three key variables (district_id; health facility_id; patient_id). It is relational as there are three forms: Patient Demographics, Patient Progress, Laboratory.

For the Progress form, for some reason, when try to enter the variables in the key (Right click form>Define key), I cannot add anything more than the patient_ID. The other options are greyed out. For all other forms, entering multiple variables in the key is no problem.

I'd appreciate some advice on what (obvious) option I am missing.

------------------------------

________________________________________ EpiData-list@lists.umanitoba.ca https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.umanitoba.ca_mailm...

End of EpiData-list Digest, Vol 160, Issue 1 ********************************************