If you use table names in the query, must you also use them when accessing the query via the default array and when using the FieldByName('Field').AsType accessors?

If my query is ...

Select ATable.AField from ATable;

Must I access AField by qryATable['AField'] or by qryATable['ATable.AField']. I notice that this is how they show up when you want to set the field for a data-aware control, but I have had luck using the non-qualified field names in the past.

Currently, I have a problem where, when I refresh my dataset, it claims it cannot find a field -- the name of which is blank.

Thanks in Advance!

Eddie Bush



[Non-text portions of this message have been removed]