I have a unique situation; I have a table tha is linked to several other tables & I want to be able to insert in to an update query the following;
The name that I am searching for and then be able to enter the new name in the update to field. I can write the other queries to update the linked records, but I don't know how to enter the data manually in the lookup fields. This will be done on a regular basis so I need a solid way of doing it.
