Page 1 of 1
creating a data interface for a complex table
Posted: November 27th, 2013, 8:19 am
by collinsod
Hi Team, can anyone advice me on how i can create a data entry interface to enter this table.
Thanks.
collinsod
Re: creating a data interface for a complex table
Posted: November 27th, 2013, 9:29 am
by khurshid.arshad
Dear collinsod
See this file.
a.
Re: creating a data interface for a complex table
Posted: November 28th, 2013, 5:30 am
by collinsod
Thanks Kurshid, its working the way i wanted.
Cheers.
Collinsod
Re: creating a data interface for a complex table
Posted: November 28th, 2013, 6:04 am
by collinsod
Hi Arshad, thanks once again for the good response. It fixed the problem I had.
Now I don't understand how you did it, kindly explain to me how the information on the Livestock species were pre-entered such that once I click on it, its automatically entered. For example, Sr 1 Pigs, Local, Sr 2 Pigs Cross/Exotic, etc.
Thanks.
Collins
Re: creating a data interface for a complex table
Posted: November 28th, 2013, 10:39 am
by khurshid.arshad
Dear collinsod
See the syntax in logic window. It is very simple and easy.
In this logic i have used four options. See details:
1 Description of Preporc:
The preproc statement declares that the following statements are executed at the beginning of a run, case, level, record, form, roster, or field.
In the simple words that Knock before entering in room.
2 Description of Curocc() :
The curocc function returns the current occurrence number for a roster, form, or record.
In simple words is that sequence number.
3 Description of $;
The dollar sign ($) is equal to current name.
4 Description of skip:
The skip statement skips to the specified field. If the field has multiple occurrences, either record or item, the occurrence number must be specified to skip to the correct occurrence.
If you need further clarification please tell me.
a.
Re: creating a data interface for a complex table
Posted: November 29th, 2013, 12:35 am
by collinsod
Aha Thanks so much Kurshid.... I must say you're a genius.
Thanks.
Collinsod
Re: creating a data interface for a complex table
Posted: March 11th, 2015, 8:54 am
by MrTaco
Hey Guys
I need a syntax on how to data entry but with no auto-completion..
I need the statement that can be able to allow only 2 or 5 people per row then skips to the next Q’s
If the household has 5 people I need a statement that will allow only 5 people and not allow not less or more...