User Experience Stack Exchange is a question and answer site for user experience researchers and experts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Let's say I have a database employees-manager and that I have two tables: employees and 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:

enter image description here enter image description here

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.

share|improve this question
up vote 2 down vote accepted

Well, assuming that all your employees get paid, sounds to me like in terms of UI it's just one simple table where the Salary field is editable.


download bmml source – Wireframes created with Balsamiq Mockups

share|improve this answer
So, to make table with those columns, to load all employees in it and then to edit their salaries? EDIT Actually, by that logic, I won't even need Salaries form, I could all do in Employees form? – Branislav Lazic Apr 20 '14 at 17:18
Yes. You do need to make it very clear which employee is marked, so people don't make mistakes here. So I'd make the Name column adjacent to the Salary column, and make sure to highlight the selected row very clearly. – Vitaly Mijiritsky Apr 21 '14 at 8:39
Ok, thank you a lot. – Branislav Lazic Apr 21 '14 at 11:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.