Thank you for the response.  But still no joy..  

The intent is when the Table I am using for the combo box changes I need the underlying table to display the new description from the table I am using as the dropdown or when I delete a row from the main table I am using as the combo box..  but when I delete a row from the main table of the combo box...The underlying table still has description ...thought I'm  using the ID field to be store in the underlying table ...IF you get my understanding...

---

Reply from Alex Hedley:

If you have a Table with your values:
ID1 | Desc
1 | desc1
2 | Desc2
Etc

Then you have another table with
ID | Field | RelatedId
1 | data | 1
If you create a query that joins the second table with the first and join the ID1 with relatedid this will show
If you update Desc the new one will show
If you deleted 1 Desc1 table 2 will still have 1 in record 1, you would need to delete that or change the join not to show up.