So what I am trying to do is that when student enter their Passport Number (Screen Shot 2), I want them to see the personal information that is matched with their own passport number.
However, currently, all the information is presented (e.g. Student A enter his/her own passport number → all the information of Student A, B, C, etcs. is shown).
Let me rephrase my question:
I used the formula " LINKTOFILTEREDVIEW(“List of student”,AND([Student Number] = [_THISROW].[Student Number],[Date of Birth] = [_THISROW].[Date of Birth]) "
I wanted to obtain such behavior; if the student’s number and the date of birth are match, show the data that is related to that student’s own.
However, I am currently expereince this behavior; no matter what data i enter, all the personal data is presented, NOT the specific data that is matched with the specific person.
I would be more than grateful if you could guide me on how to present such behavior that I am willing to carry out.