I am trying to calculate my users Destination URL based on a Y/N field in another table. Current Table is tblSubmission looking to tblProperty based on SMNPropertyID to PropertyID
Here's my Calculation:
SELECT Property1978 FROM tblProperty WHERE PropertyID = target.[@field:SMNPropertyID]
CASE
WHEN [@field:tblProperty1978] = 'Y' THEN 'h.html'
ELSE 'i.html'
END
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Hiperf
I am trying to calculate my users Destination URL based on a Y/N field in another table. Current Table is tblSubmission looking to tblProperty based on SMNPropertyID to PropertyID
Here's my Calculation:
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.