Lookup Filtering Available Entities are: 1.)Practice 2.)Preposition Steps 3.) PracticePreposition Steps: Ø Create these three entities Ø Create 1:N relationship between Practice (Parent entity) and Preposition (Child entity) Entity, Ø While creating 1:N relationship, relationship field will created in child entity(keep field name as Preposition ). Ø PracticePrepostion entity have Lookup field of both Practice and Prepostion Entity Ø Go to the Form Editor of PracticePreposition entity ->Double click the Preposition lookup filed and go to-> Related Records Filtering sections from which check ->Only show records where and then select-> dropdown value as Practice(PracticePrepositon) . The reason of selecting this value is Filter the Preposition Lookup value based on Practice filed located in PracticePreposition Entity