link between Tables

Hi All,

I want to find table link between production order-> operation of order -> component assigned to that operation

Means ..

1. as a input i will be giving production order so I should get operation 0020

2. Now as input i will give operation 0020 and in output i should get all component assigned to that operation