Problem with form fields

Hi allFirst i describe what I want to do

I have a form “group” where are 2 fields first field is groupName and this is simple text area.

Second field is departament (1 departament have few groups , 1 group is in one departament) and this is combo box.

For example

Departamnets Groups

*dep1

           -gr1-1

           -gr1-2

*dep2

           -gr2-1

           -gr2-2

And now i created “person” form

where are 3 fields

1)Name - simple text area

2)Departament - combobox

3)Group - combo box

And i have a problem:

How make group possible values depanded on chosen departament ?

I think all field shoud be editable (not computed) but i dont know write this formula.

I know my eng is weak but i hope that samoone will understand me ;).

Thx

Subject: problem with form fields

Create a view to display the First Form documents.First column e.g Department, second Groups.

In your person form,

Department field - use formula for choices - @dbcolumn(“”:NoCache;@dbName;ViewName;1)

Groups field - @dbcolumn(“”:NoCache;@dbName;ViewName;1)

On the field properties - REfresh fields on keyword change.

If the choices in Groups are dependant on Department, Use @dblookup instead.

There are some good example in the Designer Help.