I Just creating the Human Resource Database In Table Fields Employee ID as been Primary Key ,Emp Name ,DOB, Reporting To ,Address......etc..
|EMP Id||EMP Name||DOB||Email ID ||Reporting To|
Now i want to be Created an Leave Application form
If Emp Id :A0001 was login portal and he send the leave application to his Boss (S0012) Automatic I Need to fetch His email Id and i need to send the Application to his Boss
Can any one have Idea... to fetch his email id because both or Same table....
if i want in SQL then I can use Inner join Syntax but In Filemaker pro how to accesss
Base On above relationship i can able to See who and all Working Under me ??
|Emp Id||Reportess Member|