>
>There is an alternative. We do not use table references in fields. In our database the first three characters refer to the table it belongs to. For example:
>
>Ord_pk
>Ord_VenFk
>Ord_Qty

I can definitely see where that would be a good convention to use.