>I get warning message "Insufficient key field information for updating or refreshing" as I stated earlier.
>
>Thanks,
>
>Chao-Yong
Have you tried the example I have posted here? Is it working well? If so, try to change the sample to use your database and retry it. If the sample is working, once changes made for your DB, it is supposed to work too!
Maybe one thing: do you have a foreign key between your to related tables? This can help!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com