How to check records between two tables using Filemaker pro 9
i have two table. table1,table2
table1 have many records (studentexsist layout)
table2 (studentcurrent layout)
this layout have one stunumber input field
when i enter stunumber ( want to search table1 stunumber. if records not found want to display message "U entered student number are not available in table1.")
i am using filemaker pro 9
thanks in advance..
please help me..