Using external commands to import a found set of records from one database to another.
I have a main database containing student information. I am creating another database listing equipment ordered for students with special needs. When I am in my equipment database I would like the student name to pop up with the list of students from the main database that have special needs. I know that I can create a relationship linking the names of the students from the main database to the equipment database, but there are thousands of records in the main database.
There are only 350 students from the main database that require equipment. How can I have just those names pop up in my equipment database.
Can I create a script to import only those students with special needs?
Or is there another way.