Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

Form Selection Criteria (OpenInsight Specific)

At 19 MAY 1998 01:20:19PM Bryan Feddish wrote:

Maybe those of you not pondering the fate of popups in Chinese Windows can help me. :) I have an edit table where the first column is a code and the second is the description from another table. I can do this fine with Database|Edit Selection Criteria menu option by relating the code to a column. Now I want to add 2 more colums to this edit table. The 3rd column will be a code from the SAME TABLE as the code for column 1 and the 4th column will be the description just like column 2. Is there another way to do this besides creating an alias to the referenced table and joining it just like column 1?

Thanks,

Bryan

At 19 MAY 1998 01:38PM DSig (SigSolutions) wrote:

Maybe those of you not pondering the fate of popups in Chinese Windows can help me. :) I have an 

                  edit table where the first column is a code and the second is the description from another table. I can
                  do this fine with Database|Edit Selection Criteria menu option by relating the code to a column.
                  Now I want to add 2 more colums to this edit table. The 3rd column will be a code from the SAME
                  TABLE as the code for column 1 and the 4th column will be the description just like column 2. Is
                  there another way to do this besides creating an alias to the referenced table and joining it just like
                  column 1?

Bryan,

This begs the question … Why? What is the problem being solved?

The first 3 ways to do this I can think of are:

1) use of alias as you mentioned

2) use of symbolics (similar but you can not modify)

3) make 3&4 non-bound and update as 1&2 are populated

Dsig

David Tod Sigafoos ~ SigSolutions

[email protected] cis: 70302,77 voice:503-639-8080

At 19 MAY 1998 02:09PM Bryan Feddish wrote:

]]This begs the question … Why? What is the problem being solved

The codes are a "from" and "to" range.

Bryan

At 19 MAY 1998 03:11PM Dsig (SigSolutions) wrote:

Okay .. just cause I like to understand (sometimes things soak in real slow :-)

You have a tablectrl with 4 columns:

fromcode fromcodedesc tocode tocodedesc

Although the codes and descriptions may come from the same file, aren't the 'saved' positions different?

Dsig

David Tod Sigafoos ~ SigSolutions

[email protected] cis:70302,77 voice:503-639-8080

At 20 MAY 1998 07:50AM Bryan Feddish wrote:

Yes they are.

Bryan

View this thread on the forum...