Relationship

[JonyBravo]

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

 

[johndoomed]

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.

 

[rainman89]

take a look at a dlookup function and update your table with that