I have two tables in an Access database (Personnel and Programs). I need to use a DBCombo box to allow users to select an individuals code. After the user selects the code from the DBcombo box I need to display data from the two tables. There will be only one record from the "Personnel" table but multiple records from the "Program" table. I also need to be able to delete individual records from the "Program" table without affecting the Personnel table.
Any code available will help