Aliases

[Guest]

HI,

I make one project in Visio 2003. I link a shape from Visio with table from
Access Data Base.
In this Access Table I have a LookUp field.
And the problem is that in visio for this LookUp field is visualize a
number(the Id).
I want to be visualize the value of the this LookUp field which is some
string.
I heard that I can make this with "Alias".But I don't know how to make this.
And where I have to use this Aliases in Visio or in Access.
I tried to find something for Aliases in help of Visio and Access but with
no success.
Can Somebody can help me with this problem please ?

Tnank you in advanced!

 

[Larry Linson]

The appropriate solution is to eliminate the Lookup Field. Except for novice
users who always view their data in Datasheet View of the Table, they are,
as you are finding, more trouble than they are worth. Recreate the Field as
the ID (foreign key) to the Table with the string information, and join
those Tables in Queries in your Database to use them. If you link the shape
to the Table, it will still show a number in that Field, but I think you can
link the shape to the Query and you will get what you want.

Larry Linson
Microsoft Access MVP