>The only reason is that FP 2.5 table is external for VFP application and its structure can't be modified.
So you cannot change the existing ID field and how the values are generated, right? Could you send me (to
flying_fox@canada.com )the small subsets from your table1 and table2 so I could try something?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison