I have back-end tables that may not be in the same field order because of release issues. IOW a field may be added in a prior release and later added to the current release. Is there a way to specified specific fields in what would otherwise be a select * from tablename?

Table in Release 1

Field_abc
Field_def
Field_ghi

Table in Release 2
Field_abc
Field_ghi
Field_def

The remote will give me a base tables has changed if I sync to release 1 and try to connect to release 2 and vice versa. If there is a quick remote view trick to give me an updateable remote view I'll take it. Otherwise I will probable just to to SPT.

Thanks.