Alias table not recognized by Select Expert 2

[NewToCR]

I have Cus table and Cus1 alias table.
When want to put criterias in Select Expert it only recognizes one table. How to go by?

 

[DataDog]

What do you mean "How to go by?"?

Did you ever answer dgillz (Instructor) as to your "Butterfly" question? (in another post).

DataDog
'Failure Is Not An Option'

 

[NewToCR]

My 'butterfly' question was brilliantly answered by IdoMillet and Turkbear.There are stars in my post which meant I am OK.

How to go by meant that I do not know what to do with this. I though about it and decided to write a view where I can POINT to actual table AND alias table.
But is this a common problem? Alias table gets neglrcted by Select Expert?

DataDog, thanks for asking.

 

[Turkbear]

Hi,
Since the Alias is the same table by another name, any criteria applied to it would be applied to the actual table so perhaps CR just shows the 'real' one for selection criteria use..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Alias tables do appear in the select expert when I test it. Are you sure you scrolled down the field list to see all the tables available?

-LB

 

[Turkbear]

Hi,
Same here..Both are displayed..CR 10







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Toshilap]

I know...but try to use Select Expert and put different criteria to the same field of each table.
Here is where trick is LOL

 

[Turkbear]

Hi,
What 'trick' ( other than an odd thing to do)..
It allows me to do that, but, if the criteria conflict, no data will be returned..

Remember there is only 1 table involved in the report so if
you say Table1.dept = '123' and Table1Alias.dept='234' then no records will be returned...A department cannot be both 123 and 234.( using OR, however, will return 2 records - assuming unique dept_nbrs)

What are you trying to accomplish?
Perhaps some example data and the results you want..









To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

I can select two different values of the same field from each table, EXCEPT when trying to select different values on the LINKING field. The select expert recognizes both tables and let's me choose the two different values, but no records appear. If this is what is happening to you, you are probably not linking on the field that makes sense for your report. Maybe you should discuss the logic of the report you are trying to implement.

-LB

 

[Toshilap]

lbass...you are probably correct. We are implementing new system and I returned from client site today and I was told we are going to have these 'problem' fields combined into one table (I didn't know we can 'order' that).
So...whatever happens I appreciate your effort to solve my problem.

 

[Madawc]

Try using Report > Selection Formuals > Record Selection, for more flexability. Select Expert is OK when you are starting out, but coding the commands yourself is quicker once you know what you're doing.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10