I have some special requirements when adding a record. AS following:
1. When add a new record to UDT. There should be a field which could be automatically generated it’s value.
eg: There are three fields in the ‘Add record page’; region, city and shopcode,
when I choose a region value ‘East’ from the dropdown list, the dropdown list of ‘city’ will automatically contain all the cities belong to East: New york, New Jersey and so on.
Then a choose ‘New Jersey’ from the city dropdown list , the shopcode will generated ,as the format ‘NJ-0001’, The first char of the ‘New’ and ‘Jersey’
+’0001’.
Will the UDT module could do this, with the expression function help in the field definition? Or how I add this Type field to the field type dropdown list?
Wish your help.
Nic