> >
> > i picked up the idea of short table prefixes to table names while working with George Goley at MicroEndeavors and i too have grown to like it. orderno in Orders would be o_orders, i_orderno in Items and r_orderno in Releases. there is consistency in that orderno is in all field names having the same purpose or meaning.
> >
> > i do preface field names with their table names in the code but, because these fields are unique, omit table name references from the fields in queries constructed on-the-fly from the command window. i suppose this is as many other things really a matter of personal preference.
>
> That's what I do! I worked with Drew Speedie. Did he not work with George?
>
> Ord_PK, Ord_Amount, like that.
>
> Mike Yearwood
>
>
>

yes, i am not sure but i think drew did work with george.

by the way, ken murphy told me that he also knew george and had great respect for him. this came up as we discussed how helping others on forums like foxite takes valuable time but in the end builds the knowledge base of the helper as well as the person posting the question. george was as active on his forums as ken was on foxite. the result for george was a successful software and training business and ultimately an offer from bill gates to accept a major role with microsoft at redmond along with a good job for his wife. not a bad return on investing time in helping others!

Garth Groft