nuBuilder Forum

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

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

Thanks Steven..it worked

.