Hi,
I have a database, which has information on students from various academic years. Some of the fields in the tables are not the same. I cannot combine them because of dept. policy and also because of some fields being different. The issue is if I want to look up a student I have to search in each and every table.
So I wanted to find a way to be able to type the criteria which is the ID # (this field is there in every table), or the last name (also there in every table), in a box or space. And when I press search, it searches in all the tables and ouputs all the info abt the student, and also the table they belong. I am hoping that there won’t be data that exist in more than one table
So is this doable? if so how could I do it?
