Jacob,

I use a single letter field type prefix on field names. Every table has a PK field named iID. If they have a FK into another table the field is named iTableName. In SQL statements I find it much clearer to use the whole TableName.Fieldname when needed.