[EpiData-list] Problem defining the key variable for a relational

EpiData development and support epidata-list at lists.umanitoba.ca
Thu May 25 14:25:47 CDT 2017


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 at lists.umanitoba.ca [mailto:epidata-list-bounces at lists.umanitoba.ca] On Behalf Of epidata-list-request at lists.umanitoba.ca
Sent: Wednesday, May 24, 2017 1:00 PM
To: epidata-list at lists.umanitoba.ca
Subject: EpiData-list Digest, Vol 160, Issue 1

Send EpiData-list mailing list submissions to
	epidata-list at 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_mailman_listinfo_epidata-2Dlist&d=DwICAg&c=0u3nQZwm2He4OdaqbWh55g&r=YvAhZXo8QTPv4edUa47Z3gRCrNKD1cc8rxxbfCnpQvM&m=utqBp2o-qfZQ6rESQyMtOpQopmXpWAD5FE8mH9vOVRk&s=3g91rtoiPBGgR9t85h2J6-ZE3fjmtfjj_nJYpeIzb4s&e=
or, via email, send a message with subject or body 'help' to
	epidata-list-request at lists.umanitoba.ca

You can reach the person managing the list at
	epidata-list-owner at 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 at lists.umanitoba.ca>
To: "epidata-list at lists.umanitoba.ca"
	<epidata-list at lists.umanitoba.ca>
Subject: [EpiData-list] Problem defining the key variable for a
	relational	database
Message-ID:
	<MWHPR1201MB01589C72CC80AFF050E2F45696F90 at 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 at lists.umanitoba.ca>
To: EpiData List <epidata-list at lists.umanitoba.ca>
Subject: Re: [EpiData-list] Problem defining the key variable for a
	relational database
Message-ID: <89B424E3-7B17-4F75-8E4B-8106D0CD3AD1 at 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 at 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 at lists.umanitoba.ca
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.umanitoba.ca_mailman_listinfo_epidata-2Dlist&d=DwICAg&c=0u3nQZwm2He4OdaqbWh55g&r=YvAhZXo8QTPv4edUa47Z3gRCrNKD1cc8rxxbfCnpQvM&m=utqBp2o-qfZQ6rESQyMtOpQopmXpWAD5FE8mH9vOVRk&s=3g91rtoiPBGgR9t85h2J6-ZE3fjmtfjj_nJYpeIzb4s&e= 


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


More information about the EpiData-list mailing list