creating a data interface for a complex table

[collinsod]

Hi Team, can anyone advice me on how i can create a data entry interface to enter this table.


Thanks.

collinsod

[khurshid.arshad]

Dear collinsod

See this file.

a.

[collinsod]

Thanks Kurshid, its working the way i wanted.

Cheers.

Collinsod

[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

[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.

[collinsod]

Aha Thanks so much Kurshid.... I must say you're a genius.

Thanks.

Collinsod

[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...