>Hi Eric,
> I will try this. Also pls tell me how should i create index on
>one or more fields and also how should i create a primary key on
>one or more fields.
Index are created in the database. I think you use Access. Isn't it? If so, when you are in the design view of a table, press the Index button on the toolbar.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com