Conditional dropdown list
I have a table with users which among other data have those two columns:
USER Current User?
On another table's layout when create new record I would like to have a choice at dropdown list only from current users (Yes= A, D) list. In future when some user will become no longer current (No) the record in this table can not change.
Thank you for any advice how to do this.