Please find the datamodel for better understanding the question.
Product
-- Qualified LookUp table - field1(Field of Product table)
-- LookUp Flat table - field2(Field of Qualified LookUp Table)
-- field3 (Field of LookUp Flat table)
Question:
How to retrieve the field3 data?
Thanks in advance.