i have a access database named wing.mdb which is my master database i used to copy selected field alongwith data from table named pers into table named baiju in another database named pooja.mdb by a query
SELECT number, name, course INTO baiju IN 'pooja.mdb'
FROM pers;
till this it works fine. there is another table in wing.mdb named qual. i want to copy (selected fields on condition) to baiju table in pooja.mdb database.
the fields in pers.mdb is qualification and recommendation. the common field in both table is number (pers table has one number for one person and qual table has more than one entries for a person. which means that a person has done more than one course which is entered in qual table.
i want to copy qualification and recommendation field data in which qualification must be MED or LED or TYO