I have two tables; one called Data Info, and another called FileTable
Data Info has two fields, one of which is empty. The non empty field contains ID No.s of two different kinds; one kind is a straight up number, like 233, while the other has the type FFF234, where FFF can mean any type of 3 letter combo.
I want to update the first empty field with values from another table, FileTable whenever i come across an ID no. of type FFF***; the code will automatically look up the corresponding value for *** in the File table and then refresh the empty field with that no.
I know only ADO, so could the code be written in ADO instead of DAO?