var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Lookup Filter
Could someone help me out with the best way to select only teachers from a certain school (the one which the student on the form attends)? My lookup right now reads:
SELECT [First] & " " & [Last] AS [Teacher Full] FROM Teachers;
This allows me to select any teacher i have in [Teachers].
You'll need to add a WHERE clause
Originally Posted by thaas
SELECT [First] & " " & [Last] AS [Teacher Full] FROM Teachers where [school field] ='SchoolName1'