Dear All,
My search function is not working properly. I have two tables in a Parent/Child relationship: Employee and Attendance. Employee is the Parent, and Attendance is the Child. I created an EmployeeID column in Attendance table and relate it to Employee table via LookUp. I can use the following Search function easily in Attendance (gallery): Search(Attendance,txtSearchInput.Text,AttendanceID). AttendanceID is the Primary name column in Attendance. However, the moment I tried Search(Attendance,txtSearchInput.Text,Attendance,EmployeeID), I started to receive error. My gallery references ThisItem.LastName, ThisItem.FirstName, and as such, I thought I could use EmployeeID.LastName, etc., only to give error. I do not have issues using Filter, but I wanted to use Search Instead to allow me to search based on a few entries with column. The attached is my screen, if things if I set Items property to Attendances. However, when I used the Search function as indicated earlier, it gave me errors. Could you help? Your attention to this request is greatly appreciated.
Sincerely,
Isaiah A.