Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Change Table Alias on Table select screen?

edited December 2002 in End User
All,
I am trying to get a query working in RB 6.03 Pro. The query looks like so:
Table1
Table2 (Linked on field 1)
Table2 (Table2_2) (Linked on field 2)
Table3 (Linked to a field on Table2)
Table3 (Linked to a field on Table2_2)

Now, what I'm having a problem with is the Join Dialog box with the linking
of Table3. When I try to use the Join Dialog box, it shows the table (as
apposed to the table name or SQL alias generated by the system). This leads
to a list that has duplicate names in the Join Link Dialog. Ex:
Table1
Table2
Table2
Table3
Table3

The link always shows the first occurence of Table2 even when the second
Table2 (Table2_2) is the one that I want linked. This ends up causing the
query to link Table3 to the same Table2 instance instead of the two
different ones.

My question is, is there a way to edit the Table field in the Selected table
list box? Just being able to set the table name that is being displayed in
the list boxes would solve the problem.

Thanks,
- David Scheidt

Comments

This discussion has been closed.