Hi i'm relativel new to access and I have been tasked with creating a database to hold a lot fo information rather than a spreadsheet. I have managed to create the most part of the database but I am struggling with a search function. What I have is 2 tables one which holds the constant felds tha...