limit data from parent table to children table

[amyat]

hi,
Parent Table have status column 'active or not active' with radio button.
just i wanna show active rows on children table (drop down list) from parent table.

if that is bad idea, u can give me possible way.
can u give me a piece of advice.....

[amyat]

hi ,

i got idea for "Filtering a lookup menu by customizing the SQL query" video file
https://www.youtube.com/watch?v=zv8e626zv5M
thank you......