> >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.