>Now you have to remember the table name AND the abbreviation. I just have to remember the table name. See the advantage?

Yep, but I only have one or two abbreviations in my current database:

address.id_addr

where I'd probably just rename the table if I wasn't too far. Usually its id_table too.

>I have a table called ASSOC.
>
>ASSOC.iASSOC 1
>ASSOC.cASSOC "SV"
>ASSOC.cDesc "Shenandoah Villa"
>

I would do


ASSOC.iassoc 1
ASSOC.code "SV"
ASSOC.name "Shenandoah Villa"


That way, you still have your descriptive PK which can stay the same throughtout the database, and the other data will be consistant from table to table. I can't think of any docs to back me up here, so I'll just say its a personal preference.

>Well, you might as well since I'm completely missing your point. :-)

You have a StartDate and a StartDateTime which I'm guessing you threw out to show how identify the difference between types, but normally, StartDateTime, would suffice. Just being literal :-)

>How's the campaign going?

Slow, I think there are 3 of us. :-(