I have two tables in an Access db; 'Projects' and 'Vacant'. The tables are
joined by a FK vacantID.
I want to show a link on my classic asp page only if a 'Project' record has a
relational record in the Vacant Table.
I am confused as to what syntax to use in my SQL, asp or both? Can anyone
Recordset call is currently set to
SELECT projectID, vacantID
My ASP uses the following:
IF (project.Fields.Item("vacantID").Value) <> "" Then%>