Example of list...
Type Number Customer
33456 Johnsons Wax
H512A Tim Hortons
I need a list with 150 type numbers with the corresponding customer.
When I select the Type Number I want the customer to be filled in automatically. (see atached jpg file)
Users do not normally know the customer for all Type Numbers.
How can I do this in EPDM ?
Hi Gary,
Use list with alias.
Make the customer variable a list control and make the type number variable an editbox control. Tie the Type Number to the Customer by selecting the Customer variable in Input formula.
Regards,
Joy
Thanks for the tip.
My only problem is that we have multiple Type Numbers for each customer.
When I enter a customer more than once I cannot save since all --> The displayed values and aliases mst be unique.
Any other ideas?
Thanks,
Gary.
varying numbers of spaces after the customer name?
Hi Gary,
Looks like your only option is to write an add-in.
Regards,
Joy
You can use the alias but since you have multiple numbers for the same customer you need to add an Unicode Control Character. Right click in the alias field and select insert unicode control character from the drop down. You have a choice of 17 different ones and you can add them to different spots in the customer name if you need more. This will NOT insert a space but instead puts nothing that takes any text character posittions but does make a unique change to the text field. It works becuase there are a couple places that I have had to use this.
Thanks Stephen.
Works!!
You can use the alias but since you have multiple numbers for the same customer you need to add an Unicode Control Character. Right click in the alias field and select insert unicode control character from the drop down. You have a choice of 17 different ones and you can add them to different spots in the customer name if you need more. This will NOT insert a space but instead puts nothing that takes any text character posittions but does make a unique change to the text field. It works becuase there are a couple places that I have had to use this.