More specifically, I have a large table (approx. 14 million records). I also have a smaller table (approx. 7000 records) that acts as a lookup table for other information. Ideally, I would just use a join but my queries then take nearly 2 days to run. I've found that if I just add the field, the run time drops to 1-2 hours. I need to add a field from the lookup table to the big table but I don't have enough room to just create another table. I would like to be able to add a field to the big table and update the information using the smaller table. I'm not a very advanced FoxPro user so any advice in this matter or how I have set things up would be greatly appreciated.