Hi all,

I have done a lot of drill around features on existing tables but I'm stomped when I was trying to drill on a custom table that I created. I have an online program that does maintenance on the new table(data entry). I created a drop down field to inquire on the new table (users want to know what items already entered based on jobcode). here's
what I usually does.
1. Put a key code on the field in .scr file.
2. Add the key/screen field using kndef and skndef.
3. Define SELECT, RULES, OBJWIN in .or and .sr files then do srgen.

Everything seems fine except I'm not getting any data in the screen. I know there
are entries in the new table. Is there some step I forgot? Any help is highly appreciated.

Mannie.

I think I got it working. The ~SPACES KEYRNG in the DEFINE SELECT seems not to be working. Once I changed it to a value from other form field, the select works. However, my intention was to display from the beginning record if no value was entered. The users are happy with it.

Thanks.

Mannie