AnsweredAssumed Answered

How use inner join in FM

Question asked by Ragupathi on Nov 15, 2013
Latest reply on Nov 24, 2013 by Ragupathi

Hi everyone...

 

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
A0001Raj13-10-1988raj@aditya.comS0012
S0012Arun12-01-1983arun@aditya.comS0001
A0004varun07-07-1981Samy@aditya.comS0012

 

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

 

Capture1.JPG

Base On above relationship i can able to See who and all Working Under me ??

Eg:

Emp Id
Reportess Member
S0012A0001

A0004

A0009

 

 

Thanks

Ragu

Outcomes