[Question] How to filter dropdown result

[UcoxGanteng]

Description [describe your questions]

RIght now, the result of dropdown are all the column in table, so how to get with filter, such as only key value or wanted field.
Now: Sample
Table X
column 1 column 2
A 111
A 222
B 333
B 444

question: how to get only show in dropdown are A values....111, 222,

Example code [If you have any code info]

// Drop down Nermo
formList.AddField("Nermo", "sb_nrhdr", db.Varchar, form.SelectSingle).
	FieldOptionsFromTable("m_nermo", "nr_nrhdr", "nr_nrhdr").FieldNotAllowEdit().
	FieldInputWidth(3)

Others [screenshots or other info]

[eduartos]

you can provide WHERE-filter in FieldOptionsFromTable:

filterFn := func(sql *db.SQL) *db.SQL {
	return sql.Where("columnName", "=", "A")
}

formList.AddField("Nermo", "sb_nrhdr", db.Varchar, form.SelectSingle).
	FieldOptionsFromTable("m_nermo", "nr_nrhdr", "nr_nrhdr", filterFn).FieldNotAllowEdit().
	FieldInputWidth(3)

[UcoxGanteng]

Sorry, its not working, got erros

what I want to know how to get the result from first select and use the result as a compare field in second select:

formList.AddField("Nermo", "sb_nrhdr", db.Varchar, form.SelectSingle).FieldNotAllowEdit().
	FieldInputWidth(3).
	FieldOptionsFromTable("m_nermo", "nr_nrhdr", "nr_nrhdr")

formList.AddField("MstNumber", "sb_coano", db.Varchar, form.SelectSingle).
	FieldOptionsFromTable("mmaster", "ac_coano", "ac_coano",
		func(sql *db.SQL) *db.SQL {
			return sql.Table("mmaster").Where("ac_nrhdr", "=", "sb_nrhdr")

look at "sb_nrhdr" , first select as a result, and I want to use this result in second select, but its not working
Anyone can help ?
thank u