Column Prefix for Subform in ADP

C

Can

I am trying to link a continuous subform to an ADP and I get an error when I
sort the subform.

The error I get is
"The column prefix 'dbo.Day' does not match with a table name or alias name
used in the query."

Day is the name of the table.
The link Child Field is called Day_New_CVAD_ID, the link Master field is
called Day_New_CVAD_ID as well.

It works fine until I put a sort in the subform, I sort in descending order
on the Day_CVAD_Date field (Alias: CVAD_Date)

Any thoughts?
 
Top