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
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Filtering Lookup Screen
-
- Posts: 18
- Joined: Tue Nov 26, 2013 9:14 am
-
- Site Admin
- Posts: 2789
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 4 times
Re: Filtering Lookup Screen
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
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
-
- Posts: 18
- Joined: Tue Nov 26, 2013 9:14 am