OK So here's my essential Dilemma.

I have set up my Table to import from 3 excel files and 1 other table. The Excel files may or may not be updated at the time of each refresh of my Table "Candid" (for Candidates). Each record is autonumbered (meaning every refresh the number may change, because I delete all records and refresh from the files/table).

I want to enable functionality which will allow modifications...