Hi all

        Sorry for my late reply. I have solved this problem in programming C#.Net , not in MS Access. Thanks all for your advice.

Thank you for your reply.

I get data from the master table SemiFinishDtl, and Reference Tables Species,Size,ProductType.

in SemiFinishedDtl, it includes species,Size,ProductType are foreign Keys

I want to create view that data of Size from...