I have two tables, Employees table and Stipend table. On my form I have a combo box to find the related data per employee. What I would like to do is a button that when I click on it , it will clear the form and based on my combo box selection(employee name) to create a new stipend.
Both files are linked with the FileNo which is the id no of employee. Thanks in advance.