Hi everybody,
How do you select something in a comb box and automatically appear a text which is related to it? In my case, I have one field which is called "Factory_name" and it is filled with a list of values I wrote previously.
We have to send reports to our client with some type of code in a label. But, usually the factory´s name is too long to be fit in that label so we decided to write some abbreviation which identifies each factory.
For example:
- Madrid -> MAD
- Barcelona -> BAR
- Thüringen -> THU
- South Carolina - > SHC
- Burgos -> BG
The idea is when a Factory is selected from a comb box located in a form, a text box is autofilled. And then by using "CodigoRFQ" shows the following format (date-fabric(abbreviation)-ID). I asked this before in this post (https://www.accessforums.net/showthread.php?t=76096) (Tomorrow I will try and tell you about haha)
How do I make this relations?
Thank you very much for your help,
Regards.