AnsweredAssumed Answered

Updating a related payments table

Question asked by mscogna on Apr 5, 2012
Latest reply on Apr 9, 2012 by philmodjunk


Updating a related payments table


My question has two parts.  The first part being the most important.

1.)  I have a Members table with payment amount and payment due date.

When I process monthly billing, I want to write each of the found records to a payments table.

ie.  Found all records with billing date of 05/01/2012.  Create a new entry in Payments Table for

each member with the fields I want to store, ie.  Payment Amount, Date Paid, etc.

The Members Table is related to the Payments Table by MemberId ( I assume ).

Hope I explained that okay.

For the Bonus Prize:

2.)  In the screen for each member, I would like to have a layout I can go to via a button which shows

all the payment records for the member I am currently viewing.

Thanks in advance.