Hi I would like to set the default value for a text Box to a value in another table but display a different value in text box e.g. I have a Text Box called CustomerTypeID. I would like to set the Default Value to "1" so that it is stored as CustomerTypeID as "1" however, I would like the text box to display as CustomerTypeID "Regular".
This is simple to do when I am creating a Combo Box i.e. the Combo Box wizard allows me to get the values from another table, and gives the option to hide the key column, and then store the key value in the appropriate field. -- basically, I would like this functionality for a single text box as I dont need the dropdown value as I only have one value I would like this text box to display?
Any help would be great.