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..
if stunumber is the primary key of the table1 you could see if the student is available by:
1) creating a relationship from table2::stunumber and table1::stunumber
2) placing a portal ( based on table1 ) on the layout of table2