> >
> > Yes. I've used them and not used them over the years. But since learning to use the table prefix in the field names, I've grown to like it.
> >
> > Mike Yearwood
> >
> >
> >
>
> 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