Basically this is a simple question as my knowledge on .net is limited. I have two tables;
ID (int obviously)
LocationID (also int)
(there are more fields but arent relevent)
I have used the wizard to create a dataform and had all of the results displayed in textboxes. My problem is that LocationID(Main) consists of a refernance no. refering to LocationName(Location) . Unfortunatley all I can get it to display is the ID number and not the Location name as required. I heard you use Look up tables? As I say my knowledge is limited and any help would be much apprecitated.