Enable corresponding details in reports

[#1]

Hi All,

I have two table (for ex, AI, AVI), both table having common column is ID this details display into table box, when user click Name filed in AI table, now client want  expecting  whatever associate record display  into AVI table please hel me , what way can I proceed, i am tried Trigger but no propper output?

AI:

ID	Name	Desccription
101	ABC	Checking data  quality
102	BCD	Maintain data quality
103	CDE	Check Data quality

AVI:

ID	Version No	Status
101	1	Assign
101	2	WIP
101	3	Completed

Regards,

Senthil.K

[#2]

left join AI to AVI with ID as key