VERY EASY! need help tho!

[Guest]

hey guys - i have a table employee_id_list that i use as info for a combo
box. there is a main table employee_tbl as well. i want to link these table
together so when i change employee_tbl the name shows up in employee_id_list.
also want to be able to delete employee.

thanks guys! i know it is referential integrity but when i add or delete
from the main table the linked table doesnt update.

 

[Guest]

I would not use two tables - just one and add a field to indicate Departed.