Topic: Report Commands Posted: 30 Apr 2010 at 5:04am
I have a view that returns a repID (RequestedByRep), what I want to do is create a command that will run and return the rep's Name from the reps table.
SELECT {tblReps.RepName}
FROM tblReps WHERE {tblReps.RepNumber} = {tvwr_PurchaseOrder.RequestedByRep}
When I run this it says: Error - Description syntax error. What am I doing wrong?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
