Hello, i have bad eng, so don’t blame me. i have tables: postition(pos_id, pos_name), employee(emp_id, emp_name, pos_id) and they are in relation by pos_id.
In the form, in the field “Position” i’m choosing pos_name by lookup table, but in the next field “employee” i’m gettin a full list of employees with lookup table too. How i can get a list of employees only with position which i chose earlier. Thnx for answers.
See Tutorial - Dynamic Selection List in the help file.