This is a very basic question.
1) I am not able to automatically calculate the number of hours from the calculate option. I have input date and time and entered it into the calculate option but it is not giving me the correct answer. e.g. I have input date of injury and time of injury; and date of presentation and time of presentation. I need to calculate the number of hours of delay in presentation. I am not able to do that.
2) Is it possible to change the time option and exclude the seconds?
Thank you,
With regards,
Madhurita
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(a)lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request(a)lists.umanitoba.ca
Sent: Wednesday, May 24, 2017 1:00 PM
To: epidata-list(a)lists.umanitoba.ca
Subject: EpiData-list Digest, Vol 160, Issue 1
Send EpiData-list mailing list submissions to
epidata-list(a)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_mail…
or, via email, send a message with subject or body 'help' to
epidata-list-request(a)lists.umanitoba.ca
You can reach the person managing the list at
epidata-list-owner(a)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(a)lists.umanitoba.ca>
To: "epidata-list(a)lists.umanitoba.ca"
<epidata-list(a)lists.umanitoba.ca>
Subject: [EpiData-list] Problem defining the key variable for a
relational database
Message-ID:
<MWHPR1201MB01589C72CC80AFF050E2F45696F90(a)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(a)lists.umanitoba.ca>
To: EpiData List <epidata-list(a)lists.umanitoba.ca>
Subject: Re: [EpiData-list] Problem defining the key variable for a
relational database
Message-ID: <89B424E3-7B17-4F75-8E4B-8106D0CD3AD1(a)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(a)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(a)lists.umanitoba.ca
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.umanitoba.ca_mail…
End of EpiData-list Digest, Vol 160, Issue 1
********************************************
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