Design database table to check id in another table before allowing insert
Ok, I've got what I'm sure is a really simple database question, but being a total newbie I don't even know what to google, so hopefully someone can help me here.  

I'm trying to create 2 tables that are interconnected. For example, lets say I have an employee table with employee name and employee id, then I'm creating another table, employee_bonus, with employee id and bonus amount. What I want is for the employee_bonus table to automatically check with the employee table every time a row is inserted to make sure that the employee id exists in the employee table and reject the insert if not. The thing is, there could be multiple bonuses for a single employee, so I just want it to check that it exists, not make it one to one. Does that make sense? Is that possible? How would I do that and WHAT is that called?

Also, I'm doing this in MySql.

Thanks in advance!
Design database table to check id in another table before allowing insert
===

Ok, I've got what I'm sure is a really simple database question, but being a total newbie I don't even know what to google, so hopefully someone can help me here.  

I'm trying to create 2 tables that are interconnected. For example, lets say I have an employee table with employee name and employee id, then I'm creating another table, employee_bonus, with employee id and bonus amount. What I want is for the employee_bonus table to automatically check with the employee table every time a row is inserted to make sure that the employee id exists in the employee table and reject the insert if not. The thing is, there could be multiple bonuses for a single employee, so I just want it to check that it exists, not make it one to one. Does that make sense? Is that possible? How would I do that and WHAT is that called?

Also, I'm doing this in MySql.

Thanks in advance!