Main behavior (see screen capture for reference):
1.user download a new record under “Film purchases” tab which includes a country name.
2.the country name is not properly spelled as in the masterdata list (i.e: official list of countries that is used to harmonize data management)
3.if a new record is uploaded with the wrong country spelling, it creates junk data in the masterdata list and therefore requires a constant manual clean-up
As an example:
Pict. 1: you see that the column “country of origin” is a look-up to a masterdata list stored in a separated tab named “Country”, in the same table (see pict. 2 for reference)
Pict. 2: you see the “country” tab which is one of the masterdata lists that filled several other tabs such as “film purchase” (as in pict. 1)
Im a bit confused by “user downloads a new record” and how is the country name a lookup field if they actually enter it? Do you mean users use a form to create new records?
For the country part, this is easy. You can make it a Linked to another record field and so they have to choose from a list of predefined countries.
My goal is to find a way to bring their attention when they download automatically a new line/record. I was looking for a pop-up whatever it is that says please validate “country field and others” (since country is not the only one we want them to pay attention to.
Hope this helps