SQLWorks (10/3/2012)
I assume its possible that you will receive multiple payments from the same person or company where the only differentiation between records is the payment date, is this correct? Based on that I will give you my take on how to design this, it will take me a little bit to write it up.
That is correct, we can receive many payments from the same individual in many different formats. Thanks for your help!