I have two database files, one for (G)graduate students and one for undergraduates (UG).
Both the student ID number as the ID code. Programs have changed in such a way that I would like to pull G students enrolled in a specific degree program into the UG database and bring their personal information with them (name, address, phone, email, etc.).
Any ideas on how I can do this?