Hi,

ok let's say I have 2 tables:
<pre id=code><font face=courier size=2 id=code>

tbl_filmInfo tbl_filmMode
~~~~~~~~~~~~ ~~~~~~~~~~~~
id (autonumber) ----id (autonumber)
film_title (text) | film_mode (text)
actors (text) |
film_mode (number)-----|
available (yes/no)

</font id=code></pre id=code>

In Access, when I "open" the tbl_filmInfo, filmMode contains the names of the modes. When I look at the site, the values (1,2,3, etc..) are displayed.

How can I display the names? Shouldn't it be done automatically or something? <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>


Thanks,
Tony

Edited by - bloodtrain on 26 Apr 2002 09:37:41