Let's say I have a database
employees-manager and that I have two tables:
salaries. Also, let's say that
employees table have only 2 columns (emp_id and name_of_employee) and
salaries table have 3 columns (salaries_id, emp_id (foreign key) and amount). Now, the problem is that I'm not sure how to create my form for enterence of salaries since I have to choose employee from some component and selected value must contain id of employee (of course, chosing only name would make relation between tables meaningless). One of potential approaches:
Problem with this approach is if you have many employees. First, it will be painful for user to find desired employee. Second, employees are loaded "eagerly". Can someone tell me how to deal with situation like this? Thanks in advance.