Clarion - Dictionary

Author

Dictionary - "Choices"

Nightcheck

2006-01-18, 9:55 pm

Hi -

I'm using 6.1 (not a programmer) and am having a bit of a problem.

I want to use a "drop list" or "list box" and have about 35 items I
want to be able to choose from.

When I am in the Dictionary, I go to the Table and then the Column (in
this case the Column is called "Tasks"). I then click on the "Validity
Checks" tab and begin entering the tasks (separated by the | symbol) .
It works fine in either the "No check" or "Must be in list" - however,
once I reach a certain number of words (about 200 spaces) - it will not
let me enter any additional items -

Can anyone tell me if I am I doing something wrong . and if so,,, id
there any easy fix i.e., without any coding as I really don't know how
to do that)

Thanks so much in advance..

Rick

sandinzz@yahoo.com

2006-01-19, 6:55 pm

Hi Nightcheck

Rename column in your table from Tasks to TaskID. Create another table
with two columns: TaskID and Task (or TaskDescription). Create
appropriate keys and 1:Many relation between second and first table.
Set "Must be in File" for the TaskID in the first table. Save DCT and
create new App using wizard.for both tables in your DCT file.
Fill up your second - task table manually by inserting all 35 items.
Later you can change update form for first table by adding "drop list"
which has to be loaded with second table ... Wish you luck.Zoran.

Sponsored Links