Table Design to track payments

[steffers]

I have a db that tracks clients and multiple lines of coverage for each
client. Each line of coverage is assigned a group (from a list of about 8),
an effective date and a term date. What I want to add is something to make
sure we've been paid for each month for each line of coverage as long as it
is effective. I don't need to track amounts, just each month that is paid
for.

A statement might include any number of months of payments. (last month's
statement didn't show I got paid, this month's statement shows I got paid for
last month and this month combined.) I want to be able to "post" the
payments on a form from the statement and then run a report to show if a
month was skipped. I can figure out the form and report...I'm stuck how to
set up the table.

I appreciate any ideas.

Thanks,
Steph

 

[Jeff Boyce]

I don't entirely "see" your situation, so this may not fit...

If you have a pseudo-payment table (you did say no "amounts" needed) to
track what you've described, it seems to me you'd need to add a field to
your "coverage" table that points to a PseudoPaymentID, and a new table:
trelPseudoPayment
PseudoPaymentID
PseudoPaymentDate
Then you'd need to work out the coding that adds the PseudoPaymentID to the
relevant "coverage" rows.

Or maybe I don't understand, still!