Output from Access not string value

[mated922]

Hi,

When I run a query the cfoutput on my page are numbers and not the
string/value in my Access database. I used the lookup function in Access to
select the values in other tables to insert into the current field. I think
this may have something to do with it?

I have not tried yet but I guess I could set variables based on what these
numbers represent from the other tables in the database. I just started using
CF today so Im not really sure but I hope there is a better way than all those
querys!

Cheers,

Edward:confused;

[mated922]

I have been racking my brains and I understand the problem a little better. I
think?

I am building a directory of schools. In the data base I have a main table
with all the information and all of the reoccuring information comes from other
tables.

For example: I have a region table and each region has its own regionID as the
primary key. Now the output that I get is that region ID.

I feel like the problem is only a few key strokes away but I think I might
have tried to jump in with too little experience.

Cheers if you can help me out,

Edward

[OldCFer]

For example: I have a region table and each region has its own regionID as the
primary key. Now the output that I get is that region ID.

Isn't that what you would expect? You need to clarify the problem a little
better, maybe with
examples.

[philh]

Edward, an Access lookup is, as you've discovered, a special animal. What it
displays is not what's actually in your table, but a foreign key to the ID in
the lookup table.

If you're using the region table as a lookup entity for the main table, try a
JOIN query, (DISCLAIMER: the syntax shown below is NOT Access-generated)

SELECT Mytable.whateverfieldyouneed , Regions.Name
FROM Mytable
JOIN Regions on Regions.ID = Mytable.RegionID (or whatever the field is called)

HTH,