Check
Cannot access selected table error FAQ #18812
>On a form (vcx) I had a Combo "Combo1", with RowsourceType = 3, SQL statement and the actual statement
>
>Select Distinct Workshopname, Phone, City, WorkshopId from Workshops
> Into Cursor crsWorkshops
>
>
>This worked just fine until I added another combo, "Combo2" , also with RowsourceType = 3 and the statement
>
>
>Select Recno() AS Incident, DamageId from Damages
> Order BY 1 Desc Into Cursor crsIncidents
>
>
>Now Combo2 initializes fine, but Combo1 complains "Cannot access..."
>
>Workshops and Damages are both remote views.
>
>What to do?
>
>TIA & BR
--sb--