>>Thought you all would find this amusing.
>>After deciding that no harm could come from using select table1.*, table2.field1, table2.field2... and running the prg, the screen crashed. It seems that a field selected from table2 has the same name as one in table1. Back to listing all field names.
>>
>>Thanks again to all of you.
>
>You always could use FieldNames:
>
>select table1.*, table2.field1 AS Tbl2Fld1, table2.field2 AS Tbl2Fld2....
>
The field in this case is the invoice date and is the same in both sales order and invoice tables. Users can enter a future invoice date when crating the sales order so the customer can get extra time to pay the bill if it is a large sale.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn