>Yes, but you know in some instances you can determine between two fields with the same name by using the table name, for example
>
>salesorders!item_id is different from items!item_id
Yes, in this case you create 2 different aliases in you SQL query and use the alias names!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com