I named it "date" to be consistent with the rest of the badly designed tables. :) In the new version I precede everything with a type letter so I avoid that. I went with note1 and note2 because there's always exactly 2 notes, written by the computer, not the user, of a specific size.
I don't need a paid field seperate from the amount field because the pc table contains both payments and trips. The trips have a positive amount, the payments a negatve amount.
I appreciate your thought,
-Michelle
>Michelle,
>
>Here's a redesign that may work better:
>
>
>PC Table
>
>Field Type Contents
>InvDate DateTime The date and time of the transaction (avoid the name date
> as it is a reserved word)
>Notes Memo Get rid of the note1, note2 etc. stuff
>Check_num Char The check number that paid this trip (this should probably
> be in a payments file that is related to this one so you
> can handle partial payments and have a full record of all
> checks)
>rType Whatever it is
>Amount Currency The amount of the trip (original invoice amount)
>Paid Currency The amount that has been paid
>
>
>From these fields you can calculate anything you need. You might want ot keep a balance field in the customer master table, but that is optional as you can get the customer's balance anytime from the PC table. You can age the balances because the PC table tells you how much is owed and when the indebtedness occured.