Deriving the name from the code on Form

zbird

Registered User.
Local time
Today, 09:49
Joined
Nov 21, 2011
Messages
28
Hi,

I would like to derive the name of my data from a code on the form by just typing in the code in one field and let the text come up on another field.
I have created a list of the code with their description in the Tables, but I don't know how can I bring up both information at once when I enter the data in my form.

Many thanks for your help,
Susanna
 
Could you explain what you mean by "name of data"? Are you talking about metadata (i.e. data about data) or the value in the field?
 
Sorry, I thought of the value in the field. There is a list of codes in one field (you can choose one of them by using a Value box), and there is another field which will shows what the code means.
I would like to achieve that when I enter the code 'USA' in one field, in another field 'United States of America' comes up automatically.
 
You can use a combo box, the first and bound column will be the code and the second column will be the description.
 

Users who are viewing this thread

Back
Top Bottom