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

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

dsig@teleport.com cis: 70302,77 voice:503-639-8080

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

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

Bryan

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

dsig@teleport.com cis:70302,77 voice:503-639-8080

Yes they are.

Bryan

View this thread on the forum...