Filtering Lookup Screen

[arvind.acharya]

Hi,
I am trying to build tracker where all job/modules can be tracked. I require help in filtering the screen for lookup.
When I add new screen, I have lookup field (First lookup filed on page), where user will select particular job.
This works perfectly.
I have added sub form in the same page below. Here I have a second lookup field and I would like to do this.
The lookup screen for this filed contains list of all jobs and other details. I would like to filter this screen based on value in first lookup field.
Attached is screen grab for your reference.
Could you please help me?
Thanks in advance

[admin]

aa,

The Form you use for Asset_ID will need an SQL statement like SELECT * FROM asset WHERE ass_course_id = '#tas_course_id#' .

Hash Variables (#tas_course_id#) are very powerful, and can be used in different places..

https://www.nubuilder.net/documentation ... f22f2dd8c2

Steven

[arvind.acharya]

Thanks Steven..it worked

[admin]

.