Hi there!

I've three tables in my database, tblInfo, tblSavedInfo & tblCountry.
for tblInfo I have this fields - Ref: Cost: RefCountry:
for tblSavedInfo I have this fields - Ref: Cost: Country:
for tblcountry I have this fields - RefCountry: Country:

My problem is when I save from tblinfo to tblSavedInfo I want it from RefCountry on tblInfo check wich country is on tblCountry and save on tblSavedRef the country instead the refCountry.

As tblInfo has about 200.000 rows I need something to make it quick. Is there anyone that can help me please.

Thanks

I'm not completly sure that I understand what you want, but I'm pretty sure that your solution is querries. Either update or addition.

take a look at a dlookup (http://www.mvps.org/access/general/gen0018.htm) function and update your table with that