[EpiData-list] Re: EpiData-list Digest, Vol 77, Issue 8

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Thu Mar 18 04:04:15 CDT 2010


Hi Jamie,

Thank you very much; it worked in my hands and I managed to reproduce it
successfully.
I will try to apply it to the entire multilevel database

Tieble
London, UK


On 17 March 2010 17:00, <epidata-list-request at lists.umanitoba.ca> wrote:

> Send EpiData-list mailing list submissions to
>        epidata-list at lists.umanitoba.ca
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.umanitoba.ca/mailman/listinfo/epidata-list
> 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. Change the colour of data entry form;     and entering contact
>      number for each person (epidata-list at lists.umanitoba.ca)
>   2. Re: Change the colour of data entry form; and entering
>      contact number for each person (epidata-list at lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 16 Mar 2010 19:41:03 +0000
> From: epidata-list at lists.umanitoba.ca
> Subject: [EpiData-list] Change the colour of data entry form;   and
>        entering contact number for each person
> To: epidata-list at lists.umanitoba.ca
> Message-ID:
>        <bf1bb7701003161241o6a547b5fxd5d665ca74b6398b at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Dear colleagues,
>
>    I am designing relational database and would like the data entry staff
> to be able to enter the identification number (idno) and not to have to
> type
> in the contact number of each idno (person).  The field for the contact
> number should be field automatically for each idno.  More importantly, it
> should start with one for each idno.
>
> For example for idno 001 contact 1; 2; 3; 4; 5; 6; 7; 8; 9; 10
>                    for idno 002 contact 1; 2; 3;
> ..................................100
>
> Clearly, given that idno is a string; I have tried the following command
> which
> IDNO
>  AFTER ENTRY
>  IF IDNO=IDNO THEN
>  LET CONTACTNUM=1+RECORDCOUNT
>  ENDIF
>  END
> The result is not different from automatic contact number.
> Any suggestions will be appreciated.
>
> Thank you for your time and suggestions
>
> Tieble
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 16 Mar 2010 19:30:09 -0400
> From: epidata-list at lists.umanitoba.ca
> Subject: Re: [EpiData-list] Change the colour of data entry form;       and
>        entering contact number for each person
> To: epidata-list at lists.umanitoba.ca
> Message-ID: <BLU0-SMTP90051533776303A978B93FFD2D0 at phx.gbl>
> Content-Type: text/plain; charset="us-ascii"
>
> Here is one solution that requires you to have a field in the main case
> .rec file that holds the number of contacts entered so far. It may not be
> perfect, but should work for data entry and record review just fine.
>
> There are 4 files in my example
> main.qes - the Main case file
> main.chk
> contact.qes - the Contact file
> contact.chk
>
> The .chk files pass the highest contact number back and forth using the
> global variable xcon and the data entry person cannot change the contact
> number.
>
> The "before record" block in contact.chk increments xcon to give the next
> contact number, but this only gets saved back to main.rec when a new record
> is saved. If only existing records are revised and saved, the number of
> contacts does not change.
>
> This is a example of related files communicating with each other through a
> global variable.
>
> I hope this helps.
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: contact.chk
> Type: application/octet-stream
> Size: 203 bytes
> Desc: not available
> Url :
> http://lists.umanitoba.ca/pipermail/epidata-list/attachments/20100316/1fbcad2f/contact-0002.obj
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: contact.qes
> Type: application/octet-stream
> Size: 119 bytes
> Desc: not available
> Url :
> http://lists.umanitoba.ca/pipermail/epidata-list/attachments/20100316/1fbcad2f/contact-0003.obj
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: main.chk
> Type: application/octet-stream
> Size: 272 bytes
> Desc: not available
> Url :
> http://lists.umanitoba.ca/pipermail/epidata-list/attachments/20100316/1fbcad2f/main-0002.obj
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: main.qes
> Type: application/octet-stream
> Size: 154 bytes
> Desc: not available
> Url :
> http://lists.umanitoba.ca/pipermail/epidata-list/attachments/20100316/1fbcad2f/main-0003.obj
> -------------- next part --------------
>
>
> Jamie Hockin
> Ottawa
>
> On 2010-03-16, Tieble wrote:
>
> >    I am designing relational database and would like the data entry staff
> > to be able to enter the identification number (idno) and not to have to
> type
> > in the contact number of each idno (person).  The field for the contact
> > number should be field automatically for each idno.  More importantly, it
> > should start with one for each idno.
>
>
> ------------------------------
>
> ________________________________________
> EpiData-list at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
> End of EpiData-list Digest, Vol 77, Issue 8
> *******************************************
>


More information about the EpiData-list mailing list