Hi there

does anyone have a formula which can show a drop-down of existing data while entering new data for example

Company table > have a field called company name while I create an entry and type micro is there a possibility to display existing data containing the word micro. in case it doesn“t exist what is the best option to locate duplicates to compare the entries.

thanks