In access 97, Can i use either tabledef or querydef in order to get a large group of records from different tables in my database and put them together? I have multiple tables where they have the same fields of equal type, and want to bunch the data for when i run a massive search on the records... i hope i was clear enough, any ideas please let me know.. thanks..