Drop down menu "summarising" options (1 Viewer)

[maxgold]

Hello,

I would like to add a drop down menu in one of my forms that shows all the options that have already been used in this field. For example, if the field was language and I had already entered people speaking English and Polish, I would like to be able to choose English or Polish or enter a new value.

However, when I use a combination field, it gives me every single entry to that field, which leads to duplicates and also several "empty options" for all the people entered where I didn't know which language they speak.

Does anyone know how to change this so that a "summarised" version of the options is offered?

Best,
Max

 

[arnelgp]

you can use a Temporary table to save all language you have entered on another table:

tblLanguage(table)
Language (short text)

you add Index on Language field (No Duplicate).


when the form loads, reset this table, by using query:

delete * from tblLanguage (query1)

then run another query that will insert new records

insert into tblLanguage ( Language ) select language from TransactionTable where Not language is null group by language;

when you add new language on your form, you run the Insert Query again.